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

[Ruslan Zasukhin]

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

> Brilliant answer Bart!
> 
> Thanks so much for taking the time and making such a verbose effort!
> 
> 
> This should be added to the wiki.
> 
> -----
> 
> I finally realized I just wanted to retrieve the BLOB as a getstring like I
> do every other field type.
> 
> myCursor.Field(n).getstring
> 
> And NOT having it return 10 or 19.

Barry,  

Again, its ONLY Vstudio show that 10 or 19 values.
V4RB NEVER give them you into hands.
V4RB API will return you BLOB value itself!

You can check also our examples, I think at least one should be about BLOBs.

 
> I didn't want to have to know which field is a blob
> or have to query its data type first then retrieve as a blob just to get its
> value. etc.



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