There are a lot of things in VFP that were initially set up for
"User-generated" applications (that is a made-up term by the way). In other
words, the concept was users had the full VFP (well, probably Foxpro,
that's where it started) software set installed. So they could set up their
paths like the old DOS path days, etc.
In regards to generating 'distributable' applications, there are a lot of
things in VFP shouldn't be used.
Case in point: assuming a search path - using
FILE("just_filename_and_extension"). Better: use a fully path qualified
file name - FILE("driveletter:\folder\folder\file_name.extention_name").
And really, that should be done when working with any "file." Your
application should know where it's getting and storing it's data (in
regards to file access of course). Do not depend on paths, etc. MS can
really muck you up there with the later versions of Windows (aka path
'aliasing' or whatever to protect the c:\program files\ folder - tricking
the application to think it's reading a file from one place but actually
getting it from another - does anyone really install applications in
c:\program files\ anymore? ).
-Charlie
At 11:59 AM 7/27/2011 +0200, Coppens, Georges, FC (Provincialaat) wrote:
>Using file() to check the existence of a table is not safe. Have a look
>at:
>http://www.dbmonster.com/Uwe/Forum.aspx/foxpro/4747/Command-to-check-whe
>ther-a-foxpro-table-exists
>
>-----Original Message-----
>From: [email protected] [mailto:[email protected]]
>On Behalf Of Sytze de Boer
>Sent: donderdag 14 juli 2011 23:06
>To: [email protected]
>Subject: Re: No table is open
>
>I think I've found the problem
>The error comes up with error 52, No table is open in the current work
>area
>
>I'm about to test this
>Create a table
>Create a cdx with this table
>Close the table
>Delete the cdx file (I think this has happened at this client site)
>
>now type use thistable
>
>
>
>On Fri, Jul 15, 2011 at 1:18 AM, Alan Bourke
><[email protected]>wrote:
>
> > I think I had something similar recently but in FoxPro 2.6 - I had
>added
> > an index on a memo field which was all fine until the user ran a
>process
> > which did a PACK MEMO as part of its operations. This caused the CDX
>to
> > become corrupt and on attempting to open the table an "error 1113 -
>File
> > Is Not Open" was thrown, which is sort of in the same ballpark.
> > --
> > Alan Bourke
> > alanpbourke (at) fastmail (dot) fm
> >
> >
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** 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.
