RE: ROWIDs ???

Posted in 2001

Murray Wood — Wed, 10 Jan 2001 11:26:19 +1300 — source: Informix-list mailing list archive (1991-1998)

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