Although not VFP (it relates to Dataflex/Informix files) this is still relevant to VFP tables.
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Madigan Sent: 14 May 2012 17:55 To: Pro Fox Email List Subject: I have to be able to browse the whole database, but it causes corruption I have to be able to browse the whole database. If I do it in vfp 9.0, it's been causing corruption. If I use a SQL select, the largest subset a user would use is about 26,000 records from 3 different tables, that takes about 30 seconds. . I was thinking of opening the database again with the noupdate clause, but will that guarantee me no corruption? Can you corrupt an index with a file opened noupdate? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ 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.
