I am importing data from a non MySQL table into MySQL. In the table there is a text field of up to length 4000 chars. I have defined the column as "blob" in the MySQL table. I can read the text field of the source table into a variable e.g. mystring$. The MySQL table has been set, except for this data.
I thought to use SQLString = "UPDATE TheTable SET Notes = " + mystring$ + " WHERE TheTableRef = '" + Myref$ + "';" I get error: You have an error in the SQL syntax I have tried to search the manual for an example of updating a blob column from a variable and cannot find one. I don't want to save the content of the var to disk and then "load from file" because of the time it takes. Do I have another option? Kerry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]