General information
Category:
Internet applications
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only