Delete doesn't make records Gone! It just Hides them from View and Only if you have Set Deleted On!

Pack actually Does make them Gone - as does ZAP!

-K-

-----Original Message-----

From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Koen Piller

Sent: Friday, June 05, 2015 5:36 PM

To: profoxtech@leafe.com

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/80838F1CA795B14EA1AF48659F35166F1C02C9@DREXCH02.corp.globetax.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.