Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC connections to Free Tables
Message
From
10/06/1998 12:50:32
David Keene
Ibc Computer Distributors
Kitchener, Ontario, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
ODBC connections to Free Tables
Miscellaneous
Thread ID:
00106830
Message ID:
00106830
Views:
66
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
Map
View

Click here to load this message in the networking platform