How to use blob in a formula or selection criteria

[JohnWantsToKnow]

Using Crystal 9 to extract a timestamp field from an oracle database. Crystal only finds the field as a ‘Blob’ and I unable to run any formula against a blob field. Is there a quick solution to make Crystal see the field as a string or number?
T.I.A.

 

[rosemaryl]

Dear John,

Hmm, have you tried writing a sql expression? I am not sure that you can directly substring a blob field, you might consult with your Oracle DBA on solutions.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[Turkbear]

Hi,
It is is a true timestamp,it would be visible to CR..Ask the DBA what it actually is..If BLOB or CLOB, perhaps inserting a Sql expression to convert it to a Varchar will work.
The DBA can help with what Sql expression is needed.




To Paraphrase:"The Help you get is proportional to the Help you give.."