How do I retrieve a BLOB value/data (NOT segment/pic/raw/cursor) using a single Valentina SQL Statement

[Barry G. Sumpter]

Any one at all know how to do something like this?


Select ReturnValentinaBlobData(myBlob) from tbl


'I'm jut making this up
Create SP ReturnValentinaBlobData (@myBlobFieldIn IN, @myBlobDataOut OUT)
        If @myBlobFieldIn <> "" then
               mySelectedBlobResult = Select vBlob(@myBlobField) from tbl
               @myBlobDataOut = mySelectedBlobResult
        End if






BTW, the 3.5b6 is NOT crashing anywhere near as much.
Stored Procs are saving without being deleted etc.
No crash on open of DBs.



-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Barry G. Sumpter
Sent: Thursday, 25 October 2007 7:36 AM
To: 'Valentina Developers'
Subject: RE: How do I retrieve a BLOB value/data (NOT segment/raw)
inValentina SQL Statement

With just a simple sql query?

i.e.  no curs object

Select * from tbl

???

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

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