sybperl-l Archive

From: Ronald Page <Ron dot Page at asu dot edu>
Subject: RE: ct_sql and v2.08
Date: Dec 3 1997 3:45PM

> > Inserts that succeed get the same rc as ones that don't (I haven't
> > tested return codes on Selects).  What am I doing wrong?  TIA.
> 
> Actually they don't.
> 
> If ct_results() returns a result type of CS_CMD_FAIL then a flag
> is set in ct_sql() which forces  RC to be CS_FAIL.
> 
> 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";