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
_______________________________________________
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/55720801.9090200@indigo.ie
** 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.
Sometimes VFP needs more than read write of a directory. It used to show as
a table going to hell and never being seen again. Try giving the user full
rights.
Just a thought
Al
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Tormey
Sent: 05 June 2015 22:35
To: profoxtech@leafe.com
Subject: PACK AND ALL THAT
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
_______________________________________________
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/002e01d09fcf$ddde6290$999b27b0$@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.
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
_______________________________________________
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/000001d09fd5$86864020$9392c060$@powerchurch.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.
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/CACUu1Ss-JT+jTjK_L5EyH5tJFggOtihcVxizVHmcT6D9m+tK=w@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.
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.
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.
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 <jerryf@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-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/CACUu1SvaXYbFBujAa_eQNH6huHv5qAZ-GBScU0D0ZPGhJ_H8tg@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.
Another way is to reuse the deleted records. In few words : to delete a record,
I transform the (integer) key value to the negative one (mykey = -ABS(mykey)).
When I have a record to add, I lookfor the first record with a negative key. If
FOUND() I replace the data and the key with the new ones; if not, I add the record.
My primary key is "mykey FOR mykey>0"
HTH
The Foxil
_______________________________________________
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/55728E9E.7070804@wanadoo.fr
** 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.
THANK YOU TRACY. HAVE EXCLUSIVE ON , AND HAVE HAD THE CANNOT BE
ISSUED.. ALSO. SHALL TRY THE 0
CGP(BUF) .THANK YOU VERY MUCH FOR THE HELP
WILLIAM
On 05/06/15 22:21, Tracy Pearson wrote:
> 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/5574C459.5010901@indigo.ie
** 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.