Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Error message Not a Table
I am new to Visual Fox Pro 5 and can use some help.
I have a program that gives me error message:
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC Visual FoxPro Driver]Not a table.
SQL = "SELECT * FROM categoryrec WHERE code NOT LIKE 'WH%' ORDER BY name, code ASC"
Some work just fine and some give me this error message.
I have many .DBF files in this program and 1 .DBC file.
This is unlike what I am used to with the MS Access only having one database file. I am not really sure whats wrong as I only have MS access and it won't view the VFP stuff. I wonder how hard it would be to convert these files to one MS Access data base or if I could just get these to work that would be great also.
Any help would be great.
Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement