Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MySql with Long as fieldname
Message
De
10/05/2005 07:09:40
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
MySql with Long as fieldname
Divers
Thread ID:
01012387
Message ID:
01012387
Vues:
64
Hi all,

I'm trying to insert information into a MySql server from one of our customers but they have 1 field in the table with the name LONG.
If I use passthrough and put ` = backquotes around the LONG everything works ok. Now I changed everything to work with a adapter and in the UpdateNameList I used long `products.long` , if I put the quote around the first long always results in an error, but then the field just doesn't get updated.

Anybody any suggestions (since the only solution I can think of is to change the fieldname but then I have to tell the customer that he has to change the structure of the table because I can't handle the quotes, wich will leave me standing with egg all over my face of course :-) )

Guillaume
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform