Carl Reynolds said:
> 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)
Somebody needs shooting! Unless people have been silly and written lots of
code that assumes the structure of the table will never change (eg: SELECT *
FROM table, or used INSERT without listing the columns), a serial column
won't make a difference to anybody. If they *have* been silly, you should
rewrite the DML code anyway!
> so I'm having to do my updates using - you guessed it - rowids.
I hope you never need to partition the table -- rowids stop being unique
then :-)
> 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')
There is no equivalent. rowid's are meant to be secret internal things.
Don't tell me you've got other tables that have foreign key relationships to
this 'rowid' table, which I guess you must, otherwise you've got no way to
access them. rowid's aren't especially permanent -- if you need to unload
your data / recreate your table / reload the table all your rowids will be
different, and you'll be screwed!
You've really got to NOT use rowid -- it's a disaster waiting to happen!
Cheers,
Kerry "Informix was once my middle name" S
Inprise NZ
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
