[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.


More information about the fpc-pascal mailing list