BLOB field + TinyMCE not working on Insert

[JPMacDonald]

Hi Bruce,

I am using NT 7.37 + C9.0 + MSSQL 2005

I have a BLOB that is to hold email template code for later use in the system. I use the TinyMCE editor and created a local string variable to hold the data. I use the string slicing technique to move the data in and out of the BLOB to the local variable.

The problem is that the BLOB does not get updated on the initial Insert but works fine for subsequent updates.

Attached is an example app + dict, the connection string setting is in the INI file and I've included a script to build the SQL table.

Thanks for taking a look.

Regards

Parker


[attachment deleted by admin]

[Bruce]

Hi Parker,

I'm not the SQL expert, and far less the SQL blob expert, but I guess try experimenting with some clarion code to see what might be happening.

you may need to prime the blob yourself, during say the Insert (validate insert routine) and see if that helps. It's doing a normal Access:File.Insert, so you can add that in to see if there are any errors etc.

cheers
Bruce