|
|
sybperl-l Archive
Up Prev Next
From: Ronald Page <Ron dot Page at asu dot edu>
Subject: RE: ct_sql and v2.08
Date: Dec 3 1997 8:57PM
> > > What does the SQL look like that fails?
> > >
> > $cmd = "insert into ALIAS
> > (PO_ELECTRONIC_IDENTITY_KEY,
> > ALIAS_ELECTRONIC_IDENTITY_KEY,
> > CREATED_BY, CREATE_DATE) values
> > ($poIdNum, $idNum, \"EPO\", \"$datestr\")";
> > $ref = $appo->ct_sql($cmd);
> >
> > print "$appo->{'RC'} \n";
>
> The command can only fail due to a communication or hardware
> error, unless there is a trigger or constraint on the table.
>
> Is there a trigger on the table that could cause the insert to
> fail? Possibly with a raiserror?
>
Yes, there is a trigger (generated by S-Designor) and it uses
"raiserror", and that trigger is why the insert is failing. I thought I
was thinking that error would be returned. Is there a way to capture
those (raiserrors)? Thanks.
> Michael
> --
> Michael Peppler -||- Data Migrations Inc.
> mpeppler@datamig.com -||- http://www.mbay.net/~mpeppler
|
