BLOB field

[3dthies]

I have a blob field in my actual report, but the field is empty. The blob fiel is a text memo field, so there is text in the blob field.

I'm using:

CR 11
Borland Interbase Database
Firebird ODBC Connection

Can someone help?

 

[synapsevampire]

I guess you mean that it isn't displaying blob field text in the report.

It's probably the result of your ODBC driver, the issue sounds familiar with Firebird...

One method might be to use a SQL Expression formula in Crystal to CAST or CONVERT the field to a varchar or whatever Interbase supports.

Also confirm that a certain row does have text so that you can test properly.

-k

 

[3dthies]

Yes, it isn't displaying the blob field but how would you program that sql expression for a fiel "customer.memo"?

Thx