Product Compare › Forums › Multi-Edit › Support › Bug Report – SQL language matching in 9.10.04 and MEW2006 › Reply To: Bug Report – SQL language matching in 9.10.04 and MEW2006
Regarding your matching issue, the code I gave you works fine for your first three examples. Example 4 doesn’t appear to me to be legal code and if it is would require a full parser that understands conditional statements. The docs that I have, state that a BEGIN TRANSACTION is matched with a closing COMMIT TRANSACTION. In your example 4 there are two COMMIT TRANSACTION that could close the BEGIN TRANSACTION and there isn’t an easy way to handle this case with the current implementation of our matching code. Our matching code matches open/close pairs and once they are imbalanced with conditional statements, thing go down hill fast.