Michael Madigan wrote on 2012-05-14: > 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? >
Michael, IF the current version 9 application is being used for reporting only (currently), why not setup a routine that runs early AM to update/replace existing data in a new location. Inform the users the data is as of 4AM. Or, have you considered using the OLE DB access? Will this cause corruption? Tracy Pearson PowerChurch Software _______________________________________________ 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.
