Re: verify SQL syntax without running it?

From: Abel Fontes <afontes_at_email.com>
Date: Mon, 28 Jul 2003 13:53:06 -0400
Message-ID: <3F256302.8060307@email.com>

You could...

Connection.Execute strSQL, , adExecuteNoRecords

Abel Fontes

Jens Neuhalfen wrote:

> Hi Wayne,
>
> you could place the script in a transaction (
>
> begin transaction
> ..
> users script
> ..
> end transaction
>
> HTH
>
>
> Jens
>
>
> Wayne wrote:
>

>> 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.
>>
>>

>
Received on Mon Jul 28 2003 - 12:53:06 CDT