[fpc-pascal] How to insert a record and get the primary key with sqldb?

Vincent Snijders 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.

Vincent



More information about the fpc-pascal mailing list