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:
01046318
Vues:
20
>I have a form with a grid on it and the form uses a data environment as well. One of the tables is called "ABSNTCDE.DBF" and is located in E:\EMPLOYEE\DATA. The ABSNTCDE table is linked to a DBC called EMPLOYEE.DBC and it is located on E:\EMPLOYEE. When I start up the form, I get the following error:
>
>
>Error instantiating cursor object.
>Cannot find E:\Employee\Data\Absntcde.dbf in E:\Employee.dbc
>
>
>I have opened the DBC file and did a MODI DATA to see if the ABSNTCDE table was linked and it is. I have also been able to open the ABSNTCDE table easily in the command window.
>
>The following is the code I placed in the BeforeOpenTables Method.
>
>
>SET PATH TO E:\EMPLOYEE,E:\EMPLOYEE\DATA
>This.Cursor1.cursorsource = "E:\employee\data\payhrs.dbf"
>This.Cursor3.CursorSource = "E:\Employee\Data\Absntcde.dbf"
>
>
>No matter what I do, I keep getting the same error that it cannot find the table in the database. I ran the "repair database" also.


What is Your working directory?
Your path-directive is not correct. You have a coma between the paths but You need ";"

Try to
 SET PATH TO E:\EMPLOYEE; E:\EMPLOYEE\DATA
 This.Cursor1.cursorsource = "E:\employee\data\payhrs.dbf"
 This.Cursor3.CursorSource = "E:\Employee\Data\Absntcde.dbf"
 activate SCREEN
 ? set("PATH")
BTW. I wouldn't work with hardcoded paths, but I guess You do this to track the f... Error
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