Subject Re: CAST() string as BLOB for use as a memo field in VFP
Author Bhavbhuti Nathwani
Hi Helen

--- In, Helen Borrie <helebor@...> wrote:
> I can't tell in which direction you want to do the conversion...are
you storing a Firebird varchar in a VFP Memo, or is it that you want
to store a long string from VFP into a TEXT blob?

I want to create the string in FireBird backend, using a template
stored in another FireBird table (but I am still lost in this matter).

If not I just want a basically populated BLOB field from FireBird and
I can append the string (with more SQL Pass Thrus) in VFP.

The reason for such a requirement is that I want to create a flat file
for accounts ledger reporting purposes. The Narration for a given
entry in one of the FireBird tables is to be generated on the fly for
this flat file. The biggest problem is that the narration
(essentially textmerge) is user defined and changeable.

Thanks for your prompt response.