MessagePeter
Prob a bad example (using the keys) but other common names would duplicate
(ie Name, Description Qty .....)
>> Also most of the people I know who design SQL DBs usually prefix a
tablename code in front of the field
You must be joking :-) I cringe at repeating the TableName in the Surrogate
key (ie Table.TableID) but
at that self documents the natural joins between tables, (though I haven't
decided on a system for duplicate
ForeignKeys in a single table) but Table.TableShortName_ColumnName thats
almost as ugly as VB
not to mention redundant
>> Perhaps you should write your own TField that supports this
functionality.
I have now used TField.Origin for this purpose and though I ensure Fieldname
uniqueness
it is of no meaning
Neven
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
