> > My preferred method is a UDF() that interrogates a table holding one > record for each table in the system and it's next primary key. Access the > relevant record, lock it for a short period of time whilst incrementing > the next sequential record then unlock and return back the PK. This works > faultlessly in Multi user systems. >
With such a method, you have to perform integrity control prior to use it. Because your DBFs are not in a safe. Any customer is able to open your nextpk table with excel and modify it ! Gérard. _______________________________________________ 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/93F5E0FAA0D34473A8937E9B1C7CCE07@MuriellePC ** 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.
