IIRC the performance overhead for using auto incrementing keys in VFP can be relatively significant. And I did remember correctly. See the 2nd paragraph in this doc.
http://msdn.microsoft.com/en-us/library/aa976850%28VS.71%29.aspx rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rafael Copquin Sent: Thursday, April 22, 2010 8:16 AM To: [email protected] Subject: Re: taableupdate and autoincremental fields Thank you very much Dave. Your reply seems to have hit the nail right on! It is more or less what I had been doing (the manual production of the PK with a control table) since the days of VFP 6. Most of my apps since then have been changed to use autoincremental fields but then, the volumes involved were not very large or frequent as the ones I am experiencing with this particular routine. I will go back to your approach in this one and see what happens. Thanks again Rafael Copquin _______________________________________________ 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/df1eef11e586a64fb54a97f22a8bd044067b14a...@ackbwddqh1.artfact.local ** 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.
