Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Assigning Blob in Datawindow Picture Control

4 posts in Objects Last posting was on 2006-11-16 12:43:06.0Z
Smith Posted on 2006-11-16 08:27:35.0Z
Sender: 65c2.455b3861.1804289383@sybase.com
From: Smith
Newsgroups: sybase.public.powerbuilder.objects
Subject: Assigning Blob in Datawindow Picture Control
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <455c2f07.733f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Nov 2006 01:27:35 -0700
X-Trace: forums-1-dub 1163669255 10.22.241.41 (16 Nov 2006 01:27:35 -0700)
X-Original-Trace: 16 Nov 2006 01:27:35 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9120
Article PK: 736299

Dear All,

I am saving my picture control in the database as blob. I
want to set the same to a picture control which is there in
the datawindow. But there is no such property for the
same... Can any one help me.

Thanks in advance

Regards,

Smith


Chris Werner Posted on 2006-11-16 10:53:51.0Z
From: "Chris Werner" <cwAT{PleaseNoSpam}f-s.de>
Newsgroups: sybase.public.powerbuilder.objects
References: <455c2f07.733f.1681692777@sybase.com>
Subject: Re: Assigning Blob in Datawindow Picture Control
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: 62.8.156.42
X-Original-NNTP-Posting-Host: 62.8.156.42
Message-ID: <455c514f$1@forums-1-dub>
Date: 16 Nov 2006 03:53:51 -0700
X-Trace: forums-1-dub 1163678031 62.8.156.42 (16 Nov 2006 03:53:51 -0700)
X-Original-Trace: 16 Nov 2006 03:53:51 -0700, 62.8.156.42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9121
Article PK: 736298

Hi,

save it as a file (BMP, GIF, JPG, RLE or WMF) and
use syntax like follows to assign it to the picture control:

dw_1.modify("p_1.filename='picture.bmp'")

If I remember correctly you can delete the file as soon
it is assigned but I've not checked that until now.

HTH

Chris Werner


<Smith> schrieb im Newsbeitrag news:455c2f07.733f.1681692777@sybase.com...

> Dear All,
>
> I am saving my picture control in the database as blob. I
> want to set the same to a picture control which is there in
> the datawindow. But there is no such property for the
> same... Can any one help me.
>
> Thanks in advance
>
> Regards,
>
> Smith


Smith Posted on 2006-11-16 11:20:40.0Z
Sender: 65c2.455b3861.1804289383@sybase.com
From: Smith
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Assigning Blob in Datawindow Picture Control
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <455c5797.768a.1681692777@sybase.com>
References: <455c514f$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Nov 2006 04:20:40 -0700
X-Trace: forums-1-dub 1163679640 10.22.241.41 (16 Nov 2006 04:20:40 -0700)
X-Original-Trace: 16 Nov 2006 04:20:40 -0700, 10.22.241.41
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9122
Article PK: 736300

Hi Chris,

Thanks for your help, can you tel me how to save BLOB as
picture file?

Thanks in advance,

Regards,

Smith

> Hi,
>
> save it as a file (BMP, GIF, JPG, RLE or WMF) and
> use syntax like follows to assign it to the picture
> control:
>
> dw_1.modify("p_1.filename='picture.bmp'")
>
> If I remember correctly you can delete the file as soon
> it is assigned but I've not checked that until now.
>
> HTH
>
> Chris Werner
>
>
> <Smith> schrieb im Newsbeitrag
> > news:455c2f07.733f.1681692777@sybase.com... Dear All,
> >
> > I am saving my picture control in the database as blob.
> > I want to set the same to a picture control which is
> > there in the datawindow. But there is no such property
> > for the same... Can any one help me.
> >
> > Thanks in advance
> >
> > Regards,
> >
> > Smith
>
>


Bruce Armstrong [TeamSybase] Posted on 2006-11-16 12:43:06.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAMbruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Assigning Blob in Datawindow Picture Control
Organization: TeamSybase
Reply-To: NOCANSPAMbruce.armstrong@teamsybase.com
Message-ID: <q8qol2p1fgaicr41kvaeaqu9b4prck3cmj@4ax.com>
References: <455c514f$1@forums-1-dub> <455c5797.768a.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 68-190-226-38.static.lsan.ca.charter.com
X-Original-NNTP-Posting-Host: 68-190-226-38.static.lsan.ca.charter.com
Date: 16 Nov 2006 05:43:06 -0700
X-Trace: forums-1-dub 1163684586 68.190.226.38 (16 Nov 2006 05:43:06 -0700)
X-Original-Trace: 16 Nov 2006 05:43:06 -0700, 68-190-226-38.static.lsan.ca.charter.com
Lines: 53
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9123
Article PK: 736301

Retrieve it from the database using SELECTBLOB and then write it out
to a file either using FileWriteEx (newer versions of PB) or in a loop
with FileWrite (older versions of PB).

As Chris indicated, once you've assigned the filename to the picture
control you can delete the file. We do that all the time.

On 16 Nov 2006 04:20:40 -0700, Smith wrote:

>Hi Chris,
>
>Thanks for your help, can you tel me how to save BLOB as
>picture file?
>
>Thanks in advance,
>
>Regards,
>
>Smith
>
>> Hi,
>>
>> save it as a file (BMP, GIF, JPG, RLE or WMF) and
>> use syntax like follows to assign it to the picture
>> control:
>>
>> dw_1.modify("p_1.filename='picture.bmp'")
>>
>> If I remember correctly you can delete the file as soon
>> it is assigned but I've not checked that until now.
>>
>> HTH
>>
>> Chris Werner
>>
>>
>> <Smith> schrieb im Newsbeitrag
>> > news:455c2f07.733f.1681692777@sybase.com... Dear All,
>> >
>> > I am saving my picture control in the database as blob.
>> > I want to set the same to a picture control which is
>> > there in the datawindow. But there is no such property
>> > for the same... Can any one help me.
>> >
>> > Thanks in advance
>> >
>> > Regards,
>> >
>> > Smith
>>
>>