Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC connections to Free Tables
Message
De
10/06/1998 12:50:32
David Keene
Ibc Computer Distributors
Kitchener, Ontario, Canada
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Titre:
ODBC connections to Free Tables
Divers
Thread ID:
00106830
Message ID:
00106830
Vues:
65
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
Fil
Voir

Click here to load this message in the networking platform