Including tables in .app file

[aharrisreid]

In order to save lookup and SQL select time on a very busy network, I have included the smaller, readonly tables into the project in order to include them in the main .app file. Each user runs their own copy of the .app on a local drive.

Now the problem - if an attempt is made to open a lookup table more than once (the second time under a different alias from the first), the user gets an error message "File is in use" and will not open the table a second time. Inspection of the error log shows it's definitely the version of the table included in the .app that is already open, and that it is readonly. SET EXCLUSIVE is OFF.

If I take the tables out of the project and set their attributes as readonly, there is no problem, but that defeats the 'neatness' of having them bound into the .app and distributing a copy to each user's machine.

Any ideas what might be going wrong here? Is my understanding of what I am trying to do incorrect? I am using FPD2.5 (although I suspect this problem applies to FPW and VFP).

Any help would be appreciated.

Alan

 

[foxdev]

I am using FPD2.5

Pretty critical piece of info; you might have more luck posting this in the Microsoft FoxPro version 1 to 2.6 forum.

If you are using the AGAIN keyword, I agree that it seems like it should work, regardless of whether it is contained in the app or not.

A kludge that still keeps your original goal intact is to copy the lookup tables to local temp directories when the user starts the APP. Shouldn't take more than a couple seconds, I think. That way, when you change/update the APP, the new version of temp lookup tables will be created automatically. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org