Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Thankyou Sergey
I have added an autoinc field to that table which would be causing the problem. Are their any other options to use in this case, where I will probably want to upsize later ?
Regards
Darren
>VFP ODBC driver doesn't support any new features introduced after VFP6, like DBC events, AutoInc fileds, e.t.c.
>
>>VFP9
>>
>>I haven't used a VFP database for a long time, but am using it for this new project. I am accessing the database via ODBC so I can upsize the database later, but I am having trouble with one table. Every time I modify it, add a fields etc, then try and access it with odbc eg 'select * from table1' and sqlexecute, I am getting the error 'Not A Table'.
>>
>>But if I open the database in VFP, and use the table, it is fine. Other tables in the databse don't seem to be a problem, but they haven't been modified either.
>>
>>Would anyone know what I am doing wrong with this table to cause this problem.
>>
Précédent
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