Re: #sql-status

[Albert Howard <starbuckk@MAILROOM.COM>]

Most databases have a "Messages and Codes" reference.  #sql-status
should have the code number corresponding with the statement in
$sql-error.  The SQR Manual refers Oracle users to the "V2" status
code.


-- Original Message As Follows --

Subject: #sql-status
From: Jim Hardesty <jhardest@LMBERRY.COM>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: Fri, 3 Dec 1999 13:46:40 -0500

(Oracle 7.3 )

Does anyone have any documentation detailing what values end up in #sql
status
based on what error conditions in a begin-sql (duplicate key on insert,
unable to
delete, etc)?  The book just says that various appropriate values are
put into that
variable.  What would these values be?

The only one we know if that -9 means duplicate key in Oracle. What
about all the
other possible errors?

jim





---------------------------------------------------------------
This Message was Powered by Xcel Communications
Sign up for your FREE EMAIL account today at http://www.mailroom.com
Give your FAX machine an email address http://www.faxroom.com