What I was specifically looking for was the constant drvNATIVESQLCA, and
assumed that was in sqlca.h - which it isn't, it's defined in the BDE
unit. Doh! The rest of the code in the BDE help is probably
sufficient, in that case. Anyway, I'm keen to try dbiGetProp, just in
case it works now. :)
I'm in the unenviable position of having to do updates on some tables
without unique keys (and I'm not even allowed to stick serial columns
in), so I'm having to do my updates using - you guessed it - rowids.
Works to a point - the problem is of course retrieving the rowid once
you've inserted a new row, and there doesn't seem to be any equivalent
for a rowid that's like the "select DBINFO('sqlca.sqlerrd1') from
systables where tabid = 1" that we use to retrieve the value of an
inserted serial.
Thanks, I'll let you know if I still want the file.
Cheers,
Carl Reynolds Ph: +64-9-4154790
CJN Technologies Ltd. Fax: +64-9-4154791
[EMAIL PROTECTED] DDI: +64-9-4154795
PO Box 302-278, North Harbour, Auckland, New Zealand
12 Piermark Drive, North Harbour Estate, Auckland, NZ
Visit our website at http://www.cjntech.co.nz/
> -----Original Message-----
> From: Greg Amer [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 14, 1999 5:45 PM
> To: Multiple recipients of list database
> Subject: Re: [DUG-DB] (Informix) Where can I get sqlca.h?
>
> Yeah I have seen a definition for this somewhere I forget where but
> the dbiGetOrdProp didn't work with it any how. If you are still
> interested
> to have a play with it give me a yell and I'll see if I can dig it up.
>
> ----------------------------------------------------------------------
> -----
> New Zealand Delphi Users group - Database List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
application/ms-tnef
