Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MySql with Long as fieldname
Message
From
10/05/2005 07:09:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
MySql with Long as fieldname
Miscellaneous
Thread ID:
01012387
Message ID:
01012387
Views:
62
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
Next
Reply
Map
View

Click here to load this message in the networking platform