NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: JPMacDonald on April 08, 2014, 06:43:48 AM

Title: BLOB field + TinyMCE not working on Insert
Post by: JPMacDonald on April 08, 2014, 06:43:48 AM

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]

Title: Re: BLOB field + TinyMCE not working on Insert
Post by: Bruce on April 09, 2014, 04:56:49 AM

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