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-bounces@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 <tracy@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/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.