Update a BLOB field (SQL)?

[peterH]

Has anyone here ever successfully UPDATED a record with a BLOB field in it using NT and MSSQL?
Over the years I've stored thousands of documents and pictures in BLOBs but now I need to UPDATE a record with a BLOB field and NT just dies on me.

If I remove the BLOB field from the dictionary then everything works great! But since I want the users to be able to take a selfie and upload it I need this field. Could be they had a new hairdo or something which would make them want to update their pic 

I can do this in a desktop program so I think it's somehow related to NT.

If somebody know how to deal with this I'm all ears!

TIA
Peter

[broche]

Hi Peter,

Been having issues with ODBC and Posgres using blobs.  Same kind of result.  Remove the blob file or use a TPS file and all is OK.
Try to create the table using FM3 and gives me odd response.
This is the response I got from SoftVelocity.

To work out what data type to use in the CREATE statement the file driver calls the ODBC API function SQLGetTypeInfo.  For BLOB fields it asks for the SQL_LONGVARBINARY type name.  Postgresql is returning 'lo'.  Which the driver then uses to construct the CREATE statement which then gives the error.