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

[michael.vancanneyt at wisa.be]

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.

Michael.