Text type insert

Hi everybody, I have problem inserting or updating "text" type column using SQL command. Does anyone know if there is a special format to do it or how to type the insert command line to do it? Please advise Thanks Jeff

Jeff Yu wrote: > > Hi everybody, > I have problem inserting or updating "text" type column using SQL > command. Does anyone know if there is a special format to do it or how > to type the insert command line to do it? Please advise You cannot insert to a BLOB column using 'PURE' SQL in dbaccess or isql. You need to write or obtain an ESQL/C program which can insert the text into your TEXT column. I Jonathan Leffler's sqlcmd package comes with a utility, updblob, which can update the BLOB column of an existing row with the contents of a file. Art S. Kagel