Attn MySQL experts,
How do I get the same functionality for generating unique keys with a MySQL back end (specifically, in the scenario where you need to know the parent key so that you can write the corresponding key in the child tables for linking records)?
I saw a function to determine the next key in a MySQL database, but my concern is that the operation gets that key (but only gets...doesn't increment), but by the time my user finally saves the record, that key value is not accurate (unless there's some way to lock the record, but I don't think so in MySQL)?
TIA,
--Michael
©2003 vfpmcp at mbsoftwaresolutions .DOT com |
