Information générale
Catégorie:
Applications Internet
Titre:
ODBC connections to Free Tables
Hi everyone!
I'm working on a Active Server Page that INSERTs a record into a VFP 5.0 Free table on my server. The table doesn't have any indexes or keys (just kinda a scratch pad). I can't seem to get it to write though...
I get the error mesage:
[ODBC FoxPro Driver] Operation must use an updatable query.
... but I know that my SQL statment is updateable, because it is an INSERT command. I'm wondering if anyone else has experienced it. The script writes fine (about 50% of the time)if I zap the table first and enter the first record.
My SQL looks like this...
INSERT INTO buffer
(entdate, staffcode, location, partnum, stickcode1, stickcode2, problem, serial)
VALUES ('6/10/1998','501','WA05','654','654','654','654','654')
any ideas?
thanks!
David
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