Returning Blobs

Simon Labbett

unread,

Jul 10, 2003, 2:39:40 PM7/10/03

to

Hello there,

Has anyone ever returned a blob column to an Infomaker report? If so can
you enlighten me as to how to do it. We have docs stored on our DB and I
will retrieve the docs by their report id on the table. I've returned "long
raw" columns successfully, but not Blobs.
I'm using Infomaker 6.5..

Thanks in Advance,

Simon

Terry Dykstra

unread,

Jul 11, 2003, 2:18:26 PM7/11/03

to

If the blob was stored with appropiate OLE information attached to it (using
PB updateblob() function), you can simply display the blob in a report. On
the report insert a db-ole object that points to your blob.

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
http://powerbuilder.codeXchange.sybase.com/
http://www.pb9books.com

"Simon Labbett" <labb...@post.queensu.ca> wrote in message
news:ehV7HPxRDHA.283@forums-2-dub...

Chris Pollach

unread,

Jul 14, 2003, 3:27:54 PM7/14/03

to

Terry;

A much more detailed explanation!
So many acronyms .. so little time.

regards ... Chris

"Terry Dykstra" <dontreply...@forestoil.ca> wrote in message
news:#92kabhSDHA.344@forums-2-dub...
> Not completely true. In 8.0 Oracle introduced CLOB, BLOB, NCLOB, BFILE
> datatypes, in addition to the existing LONG, (LONG) RAW datatypes. Long &
> Raw are being phased out.

>
> --
> Terry Dykstra (TeamSybase)
> Please state PB / OS / DB versions in your post.
> http://powerbuilder.codeXchange.sybase.com/
> http://www.pb9books.com
>

> "Chris Pollach" <Poll...@SCC-CSC.gc.ca> wrote in message
> news:uxOk9pfSDHA.298@forums-2-dub...
> > Simon;
> >
> > "Long Raw" is Oracle's name for the generic term BLOB (Industry nick
> name).
> >
> > regards ... Chris

> >
> >
> > "Simon Labbett" <labb...@post.queensu.ca> wrote in message
> > news:ehV7HPxRDHA.283@forums-2-dub...

Terry Dykstra

unread,

Jul 14, 2003, 10:39:07 AM7/14/03

to

Not completely true. In 8.0 Oracle introduced CLOB, BLOB, NCLOB, BFILE
datatypes, in addition to the existing LONG, (LONG) RAW datatypes. Long &
Raw are being phased out.

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
http://powerbuilder.codeXchange.sybase.com/
http://www.pb9books.com

"Chris Pollach" <Poll...@SCC-CSC.gc.ca> wrote in message
news:uxOk9pfSDHA.298@forums-2-dub...
> Simon;
>
> "Long Raw" is Oracle's name for the generic term BLOB (Industry nick
name).
>
> regards ... Chris
>
>
> "Simon Labbett" <labb...@post.queensu.ca> wrote in message
> news:ehV7HPxRDHA.283@forums-2-dub...

Chris Pollach

unread,

Jul 14, 2003, 7:14:13 AM7/14/03

to

Simon;

"Long Raw" is Oracle's name for the generic term BLOB (Industry nick name).

regards ... Chris

"Simon Labbett" <labb...@post.queensu.ca> wrote in message
news:ehV7HPxRDHA.283@forums-2-dub...

Simon Labbett

unread,

Jul 16, 2003, 8:45:15 AM7/16/03

to

Thanks Terry, Can you explain more about the updateblob() function and how
I could use it?

Thans,

Simon

"Terry Dykstra" <dontreply...@forestoil.ca> wrote in message

news:%23Glc6n9RDHA.266@forums-2-dub...

Terry Dykstra

unread,

Jul 17, 2003, 11:20:17 PM7/17/03

to

See the PB documentation on how to use that function. It's not available in
IM.

--
Terry Dykstra (TeamSybase)
Techwave 2003 (PWB511: You Can Do That in InfoMaker? Cool!)
http://powerbuilder.codeXchange.sybase.com/
http://www.pb9books.com

"Simon Labbett" <labb...@post.queensu.ca> wrote in message

news:eJl9Tl5SDHA.349@forums-2-dub...