Correct this is not good practice.
Far better to use the primary key, or a unique key / index when it exists.
Moreover (with fragmentation) rowid may not be unique.
-----Original Message-----
From: owner-informix-list@iiug.iiug.org
[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Lucky Leavell
[RIS]
Sent: Wednesday, January 10, 2001 2:58 AM
To: informix-list@iiug.org
Subject: ROWIDs ???
Version 7.31
OS: AIX 4.3.3
I am fairly new to the Informix 4GL world and notice a lot of the extant
programs use ROWID to access/update rows in tables. Is this considered a
good programming practice? (Ingres had the concept of TIDs - tuple IDs -
but dtrongly recommended against their use.) It would seem to be a better
practice to use a primary key (e.g., employee number) instead... comments?
Thank you,
Lucky
Lucky Leavell Phone: (800) 481-2393 or (812) 366-4066
UniXpress - Your Source for SCO FAX: (888) 231-9640 or (812) 366-3618
1560 Zoar Church Road NE Email: lucky@UniXpress.com
Corydon, IN 47112-7374 WWW Home Page: http://www.UniXpress.com