Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

On 2016-03-24 14:17, Stephen Russell wrote:

You control freak. Let the backend do what it does so well.

https://mariadb.com/kb/en/mariadb/auto_increment-faq/

I gave up on that single table of last PKs 15 + years ago when I found that the backend already did it for us, all we had to was ask for it.

From SNL: "Jane, you ignorant slut." lol

Steve -- you might recall the original post from this thread that laid out that there were multiple levels (3+) that were needing keys at record creation time, so the AUTOINC on the backend was not an option as we were creating datasets locally and then if the user saved, we committed to the database. So your "let the backend do it" doesn't apply here.