Re: Exist clause in PL/SQL

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 13 Nov 2001 12:54:56 GMT
Message-ID: <3bf11615.571614218@news.alt.net>

On 13 Nov 2001 04:15:00 -0800, yavior_at_mercury.co.il (Yaron Avior) wrote:

>DStevens <dstevens_at_navidec.com> wrote in message news:<3BF02A3F.6288F258_at_navidec.com>...
>> Or
>> begin
>> insert into table ...
>> exception when others then -- catch any error, can also check specifically
>> for just duplicate key violation.
>> null;
>> end;
>>
>> >
>I need to execute it via VB client, through ADO connections &
>recordsets. What are my options ?

If VB, you have two options that I can see. (I'm actually using Access syntax, but I'm assuming VB is very similar when using ADO.)

Dim MyDB AS Database

SET MyDB = ....

MyDB.Execute "INSERT INTO A WHERE EXISTS ()"

Brian Received on Tue Nov 13 2001 - 06:54:56 CST