Re: Problem with Missing CDX
Le 07/11/2014 08:40, John R. Sowden a écrit : FP/DOS lives for a few more years, Congratulations ! 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/545c8696.7000...@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.
Re: problem with missing cdx file
Hi, you may use of the try..catch..endtry construction. Regards, Koen 2014-11-06 23:24 GMT+01:00 John R. Sowden jsow...@americansentry.net: I am trying to deal with a bad or missing cdx file. I have a program that recreates indices. I test for the existence of the cdx file. If found I delete it. Then I recreate the index with the various tags. Problem is the program crashes if it cannot find the index the first time. Of course it changes the header to say there is no cdx file, so my program runs fine the second time. thoughts? John [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/cacuu1stbuxn+v61a9n3ijtavz3mu106jx843qgyq7tyyq83...@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.
Re: problem with missing cdx file
On Fri, Nov 7, 2014 at 9:53 AM, Koen Piller koen.pil...@gmail.com wrote: Hi, you may use of the try..catch..endtry construction. Regards, Koen With DOS 2.6 ? ;) A+ jml --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/capqlobw9puxfz2v4emkj2w5jdotm5auj1sy3xg97o0gh7kt...@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.
Re: Problem with Missing CDX - Now uses for FP DOS
John R. Sowden wrote: FP/DOS lives for a few more years, I found a use for FPDOS for a part of my app written in VFP9. I have certain places where it is useful to be able to view and invoice/delivery note whilst doing something else. If you create a text only version of the invoice and put in a memo it is very quick and easy to bring it up in a window without having to load an external viewer or a preview window. I created the report layout in FPDOS and you can then run it TO FILE atextfile.txt then append memo to save it. As long as you don't edit the layout with FPwindows or VFP it will only have DOS records in so produces a nice clean text file. This is not the version that is printed, just a quick view version. The memos are not that big either. Just checked and 52000 memos gives an FPT size of only 88mb. Peter ___ 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/545cac76.6030...@whisperingsmith.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.
Re: problem with missing cdx file
On Thu, 6 Nov 2014, at 10:24 PM, John R. Sowden wrote: I am trying to deal with a bad or missing cdx file. I have a program that recreates indices. I test for the existence of the cdx file. If found I delete it. Personally I would open the DBF exclusively then 'delete tag all'. This will remove any references to the CDX in the DBF header. Then you should be able to delete the CDX if the above didn't already do it for you. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ 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/1415377117.4117508.188311785.0b4c8...@webmail.messagingengine.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.
RE: problem with missing cdx file
We solved this same problem with the following code in our ErrorTrap procedure: if error() = 1707 or upper(message(1)) = STRUCTURAL CDX FILE NOT FOUND. *-- ignore it, because our programs will build the index. retry which will open the fileendif When you do 'use MyDBF' it triggers the error because the CDX is missing. This code ignoresthis particular error and opens the DBF without the CDX. You can then test for the CDXand do your re-creation. Dan Covill Date: Thu, 6 Nov 2014 14:24:05 -0800 From: jsow...@americansentry.net To: profoxt...@leafe.com Subject: problem with missing cdx file I am trying to deal with a bad or missing cdx file. I have a program that recreates indices. I test for the existence of the cdx file. If found I delete it. Then I recreate the index with the various tags. Problem is the program crashes if it cannot find the index the first time. Of course it changes the header to say there is no cdx file, so my program runs fine the second time. thoughts? John --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/bay169-w343e183e0cb7fba9e478878a...@phx.gbl ** 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.
RE: problem with missing cdx file
John: Can you read my message? I pasted in 5 lines of code, which looked OK when I sent it but is all run together on the copy I got from ProFox. Dan --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/bay169-w60a762936f9ca68a63b8a28a...@phx.gbl ** 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.
RE: problem with missing cdx file
Dan Covill wrote on 2014-11-06: John: Can you read my message? I pasted in 5 lines of code, which looked OK when I sent it but is all run together on the copy I got from ProFox. Dan Dan, Isn't outlook grand with that? To fix that, add at least 4 spaces before (or after) each line. 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/000301cffa16$46e745a0$d4b5d0e0$@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.
RE: problem with missing cdx file
Thanks, Tracy. I'll try that. Dan From: tr...@powerchurch.com To: profoxt...@leafe.com Subject: RE: problem with missing cdx file Date: Thu, 6 Nov 2014 18:06:19 -0500 Dan Covill wrote on 2014-11-06: John: Can you read my message? I pasted in 5 lines of code, which looked OK when I sent it but is all run together on the copy I got from ProFox. Dan Dan, Isn't outlook grand with that? To fix that, add at least 4 spaces before (or after) each line. 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/bay169-w8421a43d7c11f60fdc4488a...@phx.gbl ** 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.
Re: Problem with Missing CDX
John Sowden: Re-formatting this msg per Tracy Pearson's suggestion: We solved this same problem with the following code in our ErrorTrap procedure:if error() = 1707 or upper(message(1)) = STRUCTURAL CDX FILE NOT FOUND. *-- ignore it, because our programs will build the index. retry which will open the file endif When you do 'use MyDBF' it triggers the error because the CDX is missing. This code ignoresthis particular error and opens the DBF without the CDX. You can then test for the CDXand do your re-creation. Dan Covill --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/bay169-w1329bf33e367bb96b2c8a...@phx.gbl ** 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.
Re: Problem with Missing CDX
On 11/06/2014 03:16 PM, Dan Covill wrote: John Sowden: Re-formatting this msg per Tracy Pearson's suggestion: We solved this same problem with the following code in our ErrorTrap procedure:if error() = 1707 or upper(message(1)) = STRUCTURAL CDX FILE NOT FOUND. *-- ignore it, because our programs will build the index. retry which will open the file endif When you do 'use MyDBF' it triggers the error because the CDX is missing. This code ignoresthis particular error and opens the DBF without the CDX. You can then test for the CDXand do your re-creation. Dan Covill --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/545c1433.2020...@americansentry.net ** 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.
Re: Problem with Missing CDX
my text disappeared. I'll try again in a bit. John On 11/06/2014 04:37 PM, John R. Sowden wrote: On 11/06/2014 03:16 PM, Dan Covill wrote: John Sowden: Re-formatting this msg per Tracy Pearson's suggestion: We solved this same problem with the following code in our ErrorTrap procedure:if error() = 1707 or upper(message(1)) = STRUCTURAL CDX FILE NOT FOUND. *-- ignore it, because our programs will build the index. retry which will open the file endif When you do 'use MyDBF' it triggers the error because the CDX is missing. This code ignoresthis particular error and opens the DBF without the CDX. You can then test for the CDXand do your re-creation. Dan Covill --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/545c17f7.7000...@americansentry.net ** 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.
Re: Problem with Missing CDX
I like the trap the error message routine. I found the sys(2018) function. I am concerned though re: when the error occurs vs. when it is trapped. I am running v2.6/DOS. I have a standard error routine that even lets me know when I come to work in the morning that an error occurred and more info than I will need to fix it, but that is a fatal error. Can I trap for the event, knowing that it might happen, without letting it happen. It sounds like errortrap is a vfp function. I tried vfp 5.0, it never ran, and by the time the next version came out I had moved to Linux for my gui os. I run 2.6/DOS either in DOS or Linux/dosemu. John On 11/06/2014 03:16 PM, Dan Covill wrote: John Sowden: Re-formatting this msg per Tracy Pearson's suggestion: We solved this same problem with the following code in our ErrorTrap procedure:if error() = 1707 or upper(message(1)) = STRUCTURAL CDX FILE NOT FOUND. *-- ignore it, because our programs will build the index. retry which will open the file endif When you do 'use MyDBF' it triggers the error because the CDX is missing. This code ignoresthis particular error and opens the DBF without the CDX. You can then test for the CDXand do your re-creation. Dan Covill --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/545c1e3f.3030...@americansentry.net ** 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.
RE: Problem with Missing CDX
John: The exact same code is in my FP 2.6 DOS version of ErrTrap, which was last modified in 2000. So it will work. The 'retry' is what exits the ErrTrap with the DBF open, without the (missing) CDX. If you don't have a generic ErrTrap procedure, you could just do on error do CheckCdx while opening the DBF's and then put it back. Dan Date: Thu, 6 Nov 2014 17:19:59 -0800 From: jsow...@americansentry.net To: profoxt...@leafe.com Subject: Re: Problem with Missing CDX I like the trap the error message routine. I found the sys(2018) function. I am concerned though re: when the error occurs vs. when it is trapped. I am running v2.6/DOS. I have a standard error routine that even lets me know when I come to work in the morning that an error occurred and more info than I will need to fix it, but that is a fatal error. Can I trap for the event, knowing that it might happen, without letting it happen. It sounds like errortrap is a vfp function. I tried vfp 5.0, it never ran, and by the time the next version came out I had moved to Linux for my gui os. I run 2.6/DOS either in DOS or Linux/dosemu. John On 11/06/2014 03:16 PM, Dan Covill wrote: John Sowden: Re-formatting this msg per Tracy Pearson's suggestion: We solved this same problem with the following code in our ErrorTrap procedure:if error() = 1707 or upper(message(1)) = STRUCTURAL CDX FILE NOT FOUND. *-- ignore it, because our programs will build the index. retry which will open the file endif When you do 'use MyDBF' it triggers the error because the CDX is missing. This code ignoresthis particular error and opens the DBF without the CDX. You can then test for the CDXand do your re-creation. Dan Covill --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/bay169-w957c07a5f4771d3347189d8a...@phx.gbl ** 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.
Re: Problem with Missing CDX
Thank you! Let's see, what did I learn. Retry, never saw it in 20 years. And testing for a specific error code with error() allows me to create custom error solutions in my one error procedure. FP/DOS lives for a few more years, John On 11/06/2014 07:42 PM, Dan Covill wrote: John: The exact same code is in my FP 2.6 DOS version of ErrTrap, which was last modified in 2000. So it will work. The 'retry' is what exits the ErrTrap with the DBF open, without the (missing) CDX. If you don't have a generic ErrTrap procedure, you could just do on error do CheckCdx while opening the DBF's and then put it back. Dan Date: Thu, 6 Nov 2014 17:19:59 -0800 From: jsow...@americansentry.net To: profoxt...@leafe.com Subject: Re: Problem with Missing CDX I like the trap the error message routine. I found the sys(2018) function. I am concerned though re: when the error occurs vs. when it is trapped. I am running v2.6/DOS. I have a standard error routine that even lets me know when I come to work in the morning that an error occurred and more info than I will need to fix it, but that is a fatal error. Can I trap for the event, knowing that it might happen, without letting it happen. It sounds like errortrap is a vfp function. I tried vfp 5.0, it never ran, and by the time the next version came out I had moved to Linux for my gui os. I run 2.6/DOS either in DOS or Linux/dosemu. John On 11/06/2014 03:16 PM, Dan Covill wrote: John Sowden: Re-formatting this msg per Tracy Pearson's suggestion: We solved this same problem with the following code in our ErrorTrap procedure:if error() = 1707 or upper(message(1)) = STRUCTURAL CDX FILE NOT FOUND. *-- ignore it, because our programs will build the index. retry which will open the file endif When you do 'use MyDBF' it triggers the error because the CDX is missing. This code ignoresthis particular error and opens the DBF without the CDX. You can then test for the CDXand do your re-creation. Dan Covill --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/545c776b.2070...@americansentry.net ** 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.