Jerry, correct, you are right. So just donot pack() and you are able to make your transaction reversible. Pack() and Zap() are for development only, they should not be used in production. To pack a temporary table ( cursor ) is completely overkill, just create a new cursor with the same name without the unwanted records, cursors are removed when your session is over. Regards, Koen
2015-06-06 0:18 GMT+02:00 jerry foote <jer...@footegroup.com>: > 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:profox-boun...@leafe.com] 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 <tr...@powerchurch.com> 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: ProFox@leafe.com 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/cacuu1svaxybfbujaa_eqnh6huhv5qaz-gbscu0d0zpghj_h...@mail.gmail.com ** 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.
