hi all
does anybody know how can i check my sql syntax in vb6 before triggering it?
thank you for your assistance
does anybody know how can i check my sql syntax in vb6 before triggering it?
thank you for your assistance
-
-
Hi,
The simplest method is to grab the sql text and paste into a new query, the go into query view, any errors will be highlighted for you.
If the query is an action query be arawe of the changes that may be made, going into the table view wil alow you to see which records are going to be changed.
If the query is built using variables, place a stop in the VBA window then rab the text from the Immediate window and place that in to the query SQL view window.
Even if the VBA you are using is not in MS Access, you can still use the MS access window, though you will have to link the tables first into a blank database, then open a new query, change to sql view and paste.
The altenate is to use an SQl manager and paste the query there. Hope this helps in some way.
Alan Hill
Comment