[fpc-pascal] How to insert a record and get the primary key with sqldb?
vincent.snijders at gmail.com
Mon Oct 24 13:33:20 CEST 2011
2011/10/24 <michael.vancanneyt at wisa.be>:
> On Mon, 24 Oct 2011, Vincent Snijders wrote:
>> 2011/10/22 Graeme Geldenhuys <graemeg.lists at gmail.com>:
>>> 1) Use a GUID created at the time you do the Insert. This also means
>>> you can do Master/Detail records with no problems at all.
>> I consider this bad advice. GUID are bad primary keys, because of
>> their size and the fact they are not sequential by design.
> You just discarded most Microsoft product designs =-)
> They use GUIDs all over the place :-)
Still, I won't use them as primary (clustered) key in Microsoft sql
server. If the business rules require a guid, it may become a unique
key in the table, but not a primary key.
More information about the fpc-pascal