How do I retrieve a BLOB value/data (NOT segment/raw) in Valentina SQL Statement

[Ruslan Zasukhin]

On 25/10/07 11:12 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

> Sorry had to press on to get things done so I changed the Blob to a large
> string.
> 
> If I could ask for your indulgence with one last scenario.
> 
> Lets say that I am running a SQL tab in Valentina Studio.
> 
> And I want to see the actual content of the blob field.
> 
> How would I retrieve the blob value in a single SQL statement?


    SELECT fldBLOB FROM T

But Vstudio will not show you content of BLOB as is.

You need click a cell,  must be show small pencil...
    click on it, this opens HEX EDITOR with  that BLOB value.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]