>Hi all
>
>I am using SQL Pass-Thru on a FireBird database to bring in a record. All is well except that the Blob sub type 0 field (which I use as a Memo in regular Remote Views successfully) comes in the SQLPT as a General field. With this I am not able to replace a Memo field (which is Blob Sub Type 0) in the RV as data type mismatches.
>
>Please advise on how to get the blob as Memo in the SQL PT. Or if this cannot be helped how to convert the General field in the SQLPT result into a Memo field for the RV purposes.

Practically it is not feasible.

Solutions:
- upgrade to VFP9SP1
- try, within the Firebird's select, to convert the Blob into a Text