CRecordset & "BLOBS"

[SpenBabe]

Is there a "easy" way to use SQL Datatype BLOBS (Binary Large Objects) with CRecordsets, RFX, CEdit boxes, etc...

We have a table with a BLOB field, & the ClassWizard created a CRecordset-derived class with a CString field. Everything works, we can DDX (with CEdit or CRichEdit) & RFX alright, until the string is bigger than 256 characters. It is the RFX_FieldText that is the root of the problem.

Do I have to change the CString to something else & use a different RFX ?

NB: The SQL database is InterBase 6.0 & DOES unlimited length strings, before anyone questions it! Spencer Window (not a joke name)

 

[SpenBabe]

Don't worry guys (& gals), I've sorted it !!!!

You can overide RFX_TEXT function with

RFX_Text(pFX, _T("[NOTES]&quot, m_NOTES, 1024, SQL_VARCHAR);

where 1024 is max size of BLOB.

NB: The larger the number, the more memory is allocated to do the RFX !!!!! Spencer Window (not a joke name)