Re: Executing SQL Statements throught ADO

"Noel" <tbal_at_go2.pl> wrote in message news:bqpgj8$go6$1_at_inews.gazeta.pl...
>
> Użytkownik "Mark Filson" <mfilson29NOSPAM_at_hotmail.com> napisał w
wiadomości
> news:0hSzb.10664$d35.6377_at_edtnps84...
> >
> > "Jan Korecki" <Jan.Korecki_at_contactor.se> wrote in message
> > news:3fcfedbb$0$53623$57c3e1d3_at_news3.bahnhof.se...
> >
> > Hi,
> >
> > For some reason the ":NEW" in the trigger is not correctly interpreted
but
> > no errors are displayed by ADO.
>
> And that the reason to use sqlplus instead of such a 'ADO' tools to
execute
> DDL statetments.
> That's what Sybrand wanted to tell you, and warn you.
> But after your response i don't care if you mess things up and will get
into
> big trouble.
> I would never use this.
> --
> Noel
>
>
>

Well perhaps Sybrand should have rephrased his response. It was a flame, pure and simple.
We currently use SQLPLUS to run the scripts but this is not the ideal solution. We need to be able to execute each line and then check for any error conditions. Hence, the reason to use a COM component to do this. Received on Fri Dec 05 2003 - 12:23:13 CST