Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Program can't find table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01046309
Message ID:
01046390
Views:
22
> I've used the comma before and had no problem in other applications
> for the SET PATH command, but as you say, it is most likely best to
> use the semi-colon. I did change the comma to a semi-colon, but this
> made no difference. I still have the same error.

OK, it was just a shot in the dark.

What's wondering me is that You get the error
can't find table X in E:\Employee.dbc
though it should be E:\Employee\Employee.dbc if I'm right. But it could be that Your working directory is E:\ and if VFP does not find anything it falls back to that. I know it sounds rediculous but, could You doublecheck the locations and if the files *are* there.

Did You try to completely comment the BeforeTable() out and set the path before You call the form (i.e. in the application's startup program.

Ah... another idea. If You work with tables that are members of a database, I think "CursorSource" does not have a path at all as the Database knows where its tables are.... wait... I'll look it up somewhere in my code ... Yep! If you have a table that belongs to a database. You have the path with the Database = ... but You do NOT have a path with CursorSource.

So the code should be:
SET PATH TO E:\EMPLOYEE; E:\EMPLOYEE\DATA

this.Cursor1.Database     =  "E:\employee\Employee.dbc"
This.Cursor1.cursorsource = "payhrs"

this.Cursor3.Database     = this.Cursor1.DataBase
This.Cursor3.CursorSource = "Absntcde"

*-- But please take the hardcoded paths away and do SET PATH
*-- somewhere outside ;-)
Could You try that?
Regards from Berlin

Frank

Dietrich Datentechnik (Berlin)
Softwarekombinat Teltow (Teltow)

Frank.Dietrich@dd-tech.de
DFPUG # 327
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform