I do not know what is your source of MYSQL_REAL_ESCAPE_STRING() and MYSQL_ESCAPE_STRING().
To use MYSQL_REAL_ESCAPE_STRING(), you need to open connection to Server using libmysql.lib/dll and provide this connection as a parameter. If you are using ODBC, you can not use this function. MYSQL_ESCAPE_STRING() works well.
Recent versions of FWH provides this function, MYSQL_ESCAPE_STRING( <cValue> )
I see error in your sql statement. Please try this:
- Code: Select all Expand view
cCmdSql := "UPDATE estilos " +;
"SET " +;
"est_cor = '" + MYSQL_ESCAPE_STRING( aFields[06] ) + "'," +;
"est_des = '" + MYSQL_ESCAPE_STRING( aFields[05] ) + "'," +;
"est_cdb = '" + MYSQL_ESCAPE_STRING( aFields[07] ) + "' " +;
"WHERE " +;
"est_mar = " + "'" + STR(VAL(aFields[03]),3,0) + "' " +;
"AND " +;
"est_est = " + "'" + aFields[04] + "'"
In case you do not have correct version of MYSQL_ESCAPE_STRING, you can also use
StrTran( cValue, "'", "\'" )
Please let us know if you still have problem.