When you delete a record it is marked for deletion and if deleted it set to 'ON' the record is not visible. If you set deleted 'OFF' the deleted records will be visible. To completely remove deleted records you must pack the file. jerry
-----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Koen Piller Sent: Friday, June 05, 2015 4:36 PM To: ProFox Email List Subject: Re: PACK AND ALL THAT Tracy is correct pack cannot be used unless you set buffering to 0. An other thing is you Should not use pack at all. Just delete and your records are gone Koen Op vrijdag 5 juni 2015 heeft Tracy Pearson <[email protected]> het volgende geschreven: > Tormey wrote on 2015-06-05: > > ONE OF OUR TEMPORARY TABLES OPTIONALLY LOGS LOGIC CODE ACTION AND > > RELATED VALUES DURING TEST RUNS OF OUR MILL SYSTEMS. CANT GET PACK > > TO WORK EXCEPT FROM WITHIN VFP. ERROR MSGS CHANT ON ABOUT > > BUFFERING, (CURSORSETPROP AND TABLE UPATE ). DELETE ALL DOES WORK, > > SO PATHS ETC MAY NOT BE THE PROBLEM. > > > > WILLAIM > > > > William, > > You are not able to PACK a table without opening it with the EXCLUSIVE > clause. > If the command in your runtime, CursorGetProp("Buffereing", 0) returns > anything other than 3, you will also have trouble with the PACK command. > > You may see the following: Command cannot be issued on a table with > cursors in table buffering mode. > > HTH, > Tracy > > > Tracy Pearson > PowerChurch Software > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/80FEBA47C28F47B6AA962454A61FE93B@jerryfootePC ** 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.
