PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

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