> <snip>
> QUESTION?
>
> Is there any other way to get the sqlca.sqlerrd1 variable, without issuing
> a SQL statement. A "C" routine would be nice, or any other method.
>
> The problem is I want to read this value directly without issuing a second
> SQL statement.
> <snip>
Carl,
Using ESQL/C, you can get a serial value generated during an insert in
sqlca.sqlerrd[1]. I believe that 4GL also uses sqlca, but I'm not sure
what the syntax would be there.
Good Luck,
Scott
********************************************************************
* Scott C. Campbell | Voice : (703)902-8218 *
* Sr. Software Development Specialist | Fax : (703)790-3391 *
* Landmark Systems Corporation | E-mail: scott@landmark.com *
* 8000 Towers Crescent Drive | *
* Vienna, VA 22182 | http://www.landmark.com *
********************************************************************