Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>Hi Rick
>How have you been?
Hi Mike. I've been doing well overall. Ups and downs like everyone else. :-) How about yourself?
>I try to avoid edge cases. RECNO() only works in a query on a single alias. That's too limiting for me. If you don't have a good PK, you have to resort to weird approaches to get around that.
>A sequential GUID primary key is always unique to each table and across multiple tables and even across multiple systems. That's the widest possible application.
Agree. A good PK is essential. We have cases where a block of records in a table will be overwritten by all CHR(0) characters from time to time, and for those records we need a way to access them uniquely. By including the nRecno field in each record (in those cases only where we're doing data fixes), we can then generate auto-fix source code to update and re-populate the record, including the PK with its original value, as we have information stored in a journaling table. Comes in handy sometimes.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement