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

[Marco van de Voort]

In our previous episode, Felipe Monteiro de Carvalho said:
> Ok, now I want to insert a record in my table and I would like to
> obtain the auto-generated PrimaryKey

This is a classic problem, since SQL simply doesn't support this.

So all DBs do something else, for postgresql there are sequence objects that
can be queried, while other allow to return the id of the autogenerated
fields.

Afaik sqldb does not abstract this yet.