SQL Validation

[Platypus1]

I have a Visual Basic 6.0 form used for querying a MS SQl 7.0 database.

I have a text box with comparison operators as buttons over it. The user can select fields from a database table via a button which pops up a dialog box containing a list box with the column names from the database.

THe comparion operators nd the database column names when select appear in the textbox. The textbox then has a partial SQl string in it which can be used to query the database in the WHERE clause.

I need to know how to validate the code in an error routine so as to pass a valid SQL statement.

Thanks.

[JHausmann]

SQL server, itself, should do a pretty good job of validating your SQL. Assemble your query and submit it to the parser...