Sender: tgl@mythos.jpl.nasa.gov
Message-ID: <35AE02EC.14ED75A6@alumni.caltech.edu>
Date: Thu, 16 Jul 1998 13:41:00 +0000
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Organization: Caltech/JPL
MIME-Version: 1.0
To: Benedikt Eric Heinen <beh@icemark.ch>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ecpg SQL-return codes?
References: <Pine.LNX.4.00.9807160927060.14138-100000@fenun.icemark.ch>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>   how do I determine the result from an SQL statement in an ecpg source?
> >From using adabas/oracle I am somewhat used to using sqlca.sqlcode, but
> when I did a simple test yesterday (trying to update a row in an empty
> table, which of course fails, since there is nothing to update in the
> table) reveiled sqlca.sqlcode to have a value of 0.

Well, it of course succeeded! :)

SQL is set-oriented, and updating no matching rows is a valid result.
Now, if you mis-type the update command so there is a syntax or naming
error, you will probably find an error return. Also, if you do a select
on a cursor, then loop through, you might find a return code of "100"
when there are no more rows to select. But updates on well-formed
queries are likely to succeed and return zero.

                  - Tom