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

[Barry G. Sumpter]

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?




-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: Thursday, 25 October 2007 4:43 PM
To: valentina at lists.macserve.net
Subject: Re: How do I retrieve a BLOB value/data (NOT segment/raw) in
Valentina SQL Statement

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

> With just a simple sql query?
> 
> i.e.  no curs object
> 
> Select * from tbl
> 
> ???

Barry, 

You misunderstanding something.

In V4RB how you do SEELCT?
You do it using 

    curs = db.SqlSelect( "SELECT ... " )

So why you asking  HOW TO GET IT without cursor?
This is just impossible.

You always get cursor as result of Vdatabase.SqlSelect().


> -----Original Message-----
> From: valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
> Sent: Thursday, 25 October 2007 4:46 AM
> To: valentina at lists.macserve.net
> Subject: Re: How do I retrieve a BLOB value/data (NOT segment/raw) in
> Valentina SQL Statement
> 
> On 24/10/07 8:44 PM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:
> 
>> 
>> OK, but how do I return the value thru V4RB with a valentina SQL
> statement?
> 
>     dim fBlob as VBLOB
> 
>     curs = db.SqlSelect( query )
> 
>     fBLOB = curs.VBLOB("fldBlob")
> 
>     fBLOB.Read()

-- 
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]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina