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

michael.vancanneyt at wisa.be michael.vancanneyt at wisa.be
Mon Oct 24 16:50:27 CEST 2011

On Mon, 24 Oct 2011, Graeme Geldenhuys wrote:

> On 2011-10-24 14:25, michael.vancanneyt at wisa.be wrote:
>> And, very important but often underestimated:
>> At least our clients can read an integer primary/foreign key aloud over the
>> phone when the need arises. I can't hear them doing that with a GUID :-)
> Enable client-side logging (our apps have a checkbox for this), and ask
> them to reproduce the error, then email the log file to you.

That won't help at all.

> Our users are mostly ex school teachers, they know near zero about
> computers, so they wouldn't have the foggiest idea of what I am talking
> about when I ask them to quote the primary key. ;-)

Of course we don't tell them to "quote the primary key" but we tell them 
'Please add the LB_ID column to the grid and tell us the value for the record".

> Why is your clients seeing primary key field values anyway? (Unless you
> primary keys are part of the data display in the UI I guess).

They don't see them as a matter of course.

But often the only way to correctly identify a record is the primary key.
And then it helps if this is an integer, not a GUID.

But now we're getting way off topic.


More information about the fpc-pascal mailing list