RE: retrieving the serial values after insert
justin hugh daly wrote:
> hi there,
>
> how does one get the value of a serial column after inserting a row? i
> haven't been able to find anything on this...
>
> thanks
> ///daly
It depends what product you're using to a certain extent. In both 4GL and=
ESQL/c it is avaailable in the SQLCA record. Under dbaccess you can =
retrieve it using the DBINFO() function, but this is a version 7.x =
feature, and not available in version 5. If you supply the details of =
what you're running and the context, it makes your chances of a detailed =
answer considerably higher.
RET
+------------------------------------------+
| Richard Thomas |
| DBA - Marketing Information Systems |
| Optus IT |
| email: richard_thomas@yes.optus.com.au |
| Ph: +61 2 9342 7188 |
| "My opinions are my opinions" |
+------------------------------------------+