Re: verify SQL syntax without running it?

Originally posted by Wayne
> I'm using VB + ADO to access an Oracle back end. I'm writing an
> end-user
> query tool that builds and executes SQL. Is there a way I can
> check the SQL
> syntax against the RDBMS without actually returning a resultset?
>
> Thanks.

Opening a cursor causes the SQL to be parsed and will raise an error if there is a syntax error. You don't have to fetch any data back.

--
Posted via http://dbforums.com