Subject | CAST() string as BLOB for use as a memo field in VFP |
---|---|
Author | Bhavbhuti Nathwani |
Post date | 2007-11-19T06:40:40Z |
Hi all
I would like to do the following from VFP as an SQL Pass Through
SELECT CAST('Opening Balance' AS BLOB SUB_TYPE 0) AS mNarration from
MACCOUNTS
I cannot do so even in FlameRobin. Please advise what I am doing wrong.
The reason for this is that I have unknown lengths of string for this
field and would like to bring it in as Memo field in VFP.
Please advise.
I would like to do the following from VFP as an SQL Pass Through
SELECT CAST('Opening Balance' AS BLOB SUB_TYPE 0) AS mNarration from
MACCOUNTS
I cannot do so even in FlameRobin. Please advise what I am doing wrong.
The reason for this is that I have unknown lengths of string for this
field and would like to bring it in as Memo field in VFP.
Please advise.