Hi Dave, When I converted a couple VFP apps to MySQL, I went the SPT route which worked great. I chose the route of:
1) insert blank record 2) commit 3) get last_insert_id from backend 4) repopulate the spt cursor Today, I would generate my pk id's on the front end using GUIDs. While it is easy to let the backend handle this task, having the front end do it with GUIDs means you can have a totally disconnected design. Think offline views that actually work. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
