Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hello All,
Message() returns "Connectivity Error[Microsoft][ODBC Microsoft access Driver] Syntax error in Insert Into Statement"
Using a VFP6, I use my connection to update on this database 6 other tables with no real problems only on this one table do I have this issue. Yes, the checkbox is selected in "Send SQL Updates" i nthe modify of the view.
The fields are tstatus c(10),filename c(30), name c(30), date c(10), desc c(2), and id N (in access this is a long integer). The table is indexed in ID
and no duplicates are allowed. Buffering in set to 5, and multilocks are on.
My prodedure of next_id verfies that when I add a new record, id is unique.
When I try to edit a record, I get the same message.
Any ideas of where to search or try to resolve this puzzle would be GREATLY appreciated.
Sandy
Any
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