>Hi Bret...
>
>I am struggling with the same issue of storing Signature Pad's biomatrix data into a memo fields. The data is a long string of 0,1 and 2's. It can be upto 19000 bytes long.
>
>If use a plain replace command on a VFP table, it works fine.
>
> USE Sig
> REPLACE sig_date WITH lcSig_data
>
>But, if I use a SQL passthrough command such as :
>
> lcSQL = "UPDATE Sig SET sig_data = ?lcSig_data WHERE iid_numb = ?lnId "
> =SQLEXEC(gnC, lcSQL, 'Sig1')
>
>I loose part of the data.
>
>If you find any remedy to the situation, please keep me informed.
>
>Raza Malik
You might check to see if your connection has a CLOB or a Long Text Buffer (chr) and adjust those.
I have since left the COM world for using SQL Server through Cold Fusion.
So the original question is no longer needed, but I have see where my connection to the database through Cold Fusion has to have the CLOB or a Long Text Buffer (chr) settings set correctly or I lost memo data.
I hope this helps.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope