Judith Barer wrote:
I have developed a VFP 8.0 app with table buffering used in most of the forms. This all works fine. I use transactions and tableupdate and it's working fine. I have to write a program that will read in an xml file every day and update appropriate records in a table that is used in the main app. Do I have to use buffering in this program because the table may be in open in the main app or can I just use SQL insert, update and delete commands without buffering?
Hi Judith,
You can use either. Make sure exclusive of OFF in this program as the tables will be opened elsewhere. Doing updates like this on a single table I would just use SQL insert for new records or RLOCK()/update for updating existing records. If you are updating more than one table I would use buffering.
HTH Peter _______________________________________________ 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 ** 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.
