Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I'm out of ideas
Message
From
29/01/2006 14:25:59
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
I'm out of ideas
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01091278
Message ID:
01091278
Views:
70
I am trying to catch the choice of the wrong table name. If a user picks the wrong table, I want to display a messagebox that tells them to choose another file, then on clicking OK the user is returned to the getfile() routine. However, I am getting table is already open errors and must be opened exclusively. I have tried quite a few ideas but the errors persist. There must be a way of doing this. Do you know how?

Here is the main bit of code that I am using to open a table.
pcFileName = ""
pcFileName = Getfile('DBF')

Select 0 && Selects the first available work area
Use (pcFileName) Alias crime Exclusive
Select crime

Index On crimedate Tag crimedate && Thanks Sergey
* Set order to that TAG
Set  Order To crimedate
I ain't skeert of nuttin eh?
Yikes! What was that?
Next
Reply
Map
View

Click here to load this message in the networking platform