PDA

View Full Version : VBA - SQL Syntax checker function



Movian
11-21-2013, 06:35 AM
Hey before i started working on a VBA function to check SQL syntax I wanted to see if anyone here had something similar already or knew of one already available.

Essentially i want to be able to pass the SQL as a string to the function and get back a variant True or string error message.

If not I will start looking into coding this myself, (I am introducing a feature for our clients that allows them to pass a SQL string and the system exports the results set to an excel spread sheet. That works great unless there is a problem with the SQL so trying to minimize that problem).


As always any help is appreciated.