FiveTech Support Forums

Dear friends:
Can somebody post a small sample about how use fields names on variables?
Something like this:

cField := "FIELD1"

oServer:Query("INSERT INTO MyTable ( '"+ cField + "') VALUES ('"+ cField + "' + '100.00') ,")

I got: Sintaxis error near FIELD1.

Thanks in advance.

Hi Francisco,

I do not understand the use of cField in the final part of your query if you want to insert a row (append). Try:

Hi, ADutheil . Thanks for your reply.
Yes, your are right.

But the error still showing. MySQL recognizes the value of the variable, but always shows the syntax error.
For example, SQLyog gives the same error in this sample;

Is there other idea?

Try



EMG

Enrico, your are great...!!!

It's working!
I had tried a thousand ways and never occurred to me to enter the numeric value without quotes.
Thank you very much.

Best regards