Verifying SQL Syntax

[Uzi Baruch]

Hi!



Is there a way to verify an sql syntax befor running a command, i have a
query builder and i need to enable sql check on the user query befor running
it.



Thanks,

Uzi

 

[Miha Markic]

Hi Uzi,

Not directly.
You might, however, add a nonsense condition to your query, such as WHERE
1=0 and execute it against database.

 

[Uzi Baruch]

Thanks,

but i did found something - you can put SET NOEXEC ON befor the SQL
statement, and the command knows not to execute it agaisnt the data source

 

[Miha Markic]

Hi Uzi,

Yes, but this is SQL server specific.
Now that I think about it, you might also try using IDbCommand.Prepare
method.
I didn't try it, but it should verify query on providers that support it.