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.