Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Program can't find table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01046309
Message ID:
01046390
Vues:
21
> 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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform