how to check the syntax of a user defined sql script

[cszoli]

Hello !

I want to design a query screen. The user sees the available fields, and writes the selecting conditions for every fields. I want to create an SQL script from these conditions, but i want to check the query syntax before run.
How to do it ?

MZ

[Claude]

When I am unsure of a SQL statement I put the Open/Execute in a try..except construct.