Quote: >>Oh, so you're using remote data. Normally the remote database

has its own method of key generation, such as autoincrement fields in

MySQL. In those cases, you don't generate the ID locally; you simply

commit the new record without a value in the ID field, and then call

the database server function that returns the ID of the last record

that was inserted. You can then replace the iID field of the local

record with that value.

I see from your DSN that you are using Firebird as your database. I

don't have any experience with that product, so I'll leave it to

others to fill in the specifics as to how to best do this with

Firebird.

Yes Firebird has a key generator but has to be called manually as I

did above, though the assignment statement before the wait window line

still is unpopulated so I am working on it. But it seems that we have

to get the next key just like we do in VFP <g>.

Also MySQL if used with a non-open-source product is not free to use.

Am I correct in understanding?