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.

tableblob

5 posts in DataWindow Last posting was on 2008-11-03 16:57:53.0Z
Nacho Posted on 2008-10-30 11:55:44.0Z
From: "Nacho" <nparaled@sgv.es>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: tableblob
Lines: 49
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_005E_01C93A8E.ECAB34E0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4909a0c0@forums-1-dub>
Date: 30 Oct 2008 03:55:44 -0800
X-Trace: forums-1-dub 1225367744 10.22.241.152 (30 Oct 2008 03:55:44 -0800)
X-Original-Trace: 30 Oct 2008 03:55:44 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88080
Article PK: 417333

Hi,
 
how can I capture or set the data blob of a column tableblob?
 
this not work:
dw_1.Object.Data[ 1, 7]
 
thanks.


"Manuel Espinoza" <jmespinoza_no_spam Posted on 2008-10-30 15:42:45.0Z
From: "Manuel Espinoza" <jmespinoza_no_spam@seicom_dot_com_dot_mx>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4909a0c0@forums-1-dub>
Subject: Re: tableblob
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4909d5f5@forums-1-dub>
Date: 30 Oct 2008 07:42:45 -0800
X-Trace: forums-1-dub 1225381365 10.22.241.152 (30 Oct 2008 07:42:45 -0800)
X-Original-Trace: 30 Oct 2008 07:42:45 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88081
Article PK: 417335

See UpdateBlob / SelectBlob in the help.





"Nacho" <nparaled@sgv.es> escribió en el mensaje
news:4909a0c0@forums-1-dub...
Hi,

how can I capture or set the data blob of a column tableblob?

this not work:
dw_1.Object.Data[ 1, 7]

thanks.


Nacho Posted on 2008-10-31 07:20:16.0Z
From: "Nacho" <nparaled@sgv.es>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4909a0c0@forums-1-dub> <4909d5f5@forums-1-dub>
Subject: Re: tableblob
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <490ab1b0@forums-1-dub>
Date: 30 Oct 2008 23:20:16 -0800
X-Trace: forums-1-dub 1225437616 10.22.241.152 (30 Oct 2008 23:20:16 -0800)
X-Original-Trace: 30 Oct 2008 23:20:16 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88085
Article PK: 417340

No, I want to capture the value of dw, not of the database

Thanks.

> See UpdateBlob / SelectBlob in the help.
>
>
>
>
>
> "Nacho" <nparaled@sgv.es> escribió en el mensaje
> news:4909a0c0@forums-1-dub...
> Hi,
>
> how can I capture or set the data blob of a column tableblob?
>
> this not work:
> dw_1.Object.Data[ 1, 7]
>
> thanks.
>
>


"Manuel Espinoza" <jmespinoza_no_spam Posted on 2008-10-31 15:53:54.0Z
From: "Manuel Espinoza" <jmespinoza_no_spam@seicom_dot_com_dot_mx>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4909a0c0@forums-1-dub> <4909d5f5@forums-1-dub> <490ab1b0@forums-1-dub>
Subject: Re: tableblob
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <490b2a12@forums-1-dub>
Date: 31 Oct 2008 07:53:54 -0800
X-Trace: forums-1-dub 1225468434 10.22.241.152 (31 Oct 2008 07:53:54 -0800)
X-Original-Trace: 31 Oct 2008 07:53:54 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88088
Article PK: 417343

Do you mean to get column's value into a variable and viceversa?

I don´t think that the dw support the blob datatype. Perhaps a
String(char(32768)) column would work for your purpose?
If that's the case, something like this should work:


//To get the column's data
String ls_sample
ls_sample = dw_1.Object.stringcolumn[1]

//To set column from a blob var
dw_1.Object.stringcolumn[1] = String(blob_var)



HTH


"Nacho" <nparaled@sgv.es> escribió en el mensaje
news:490ab1b0@forums-1-dub...

> No, I want to capture the value of dw, not of the database
>
> Thanks.
>
>> See UpdateBlob / SelectBlob in the help.
>>
>>
>>
>>
>>
>> "Nacho" <nparaled@sgv.es> escribió en el mensaje
>> news:4909a0c0@forums-1-dub...
>> Hi,
>>
>> how can I capture or set the data blob of a column tableblob?
>>
>> this not work:
>> dw_1.Object.Data[ 1, 7]
>>
>> thanks.
>>
>>
>
>
>


Nacho Posted on 2008-11-03 16:57:53.0Z
From: "Nacho" <nparaled@sgv.es>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4909a0c0@forums-1-dub> <4909d5f5@forums-1-dub> <490ab1b0@forums-1-dub>
Subject: Re: tableblob
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <490f2d91@forums-1-dub>
Date: 3 Nov 2008 08:57:53 -0800
X-Trace: forums-1-dub 1225731473 10.22.241.152 (3 Nov 2008 08:57:53 -0800)
X-Original-Trace: 3 Nov 2008 08:57:53 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88094
Article PK: 417349

Any other suggestions?


Thanks.

> No, I want to capture the value of dw, not of the database
>
> Thanks.
>
> > See UpdateBlob / SelectBlob in the help.
> >
> >
> >
> >
> >
> > "Nacho" <nparaled@sgv.es> escribió en el mensaje
> > news:4909a0c0@forums-1-dub...
> > Hi,
> >
> > how can I capture or set the data blob of a column tableblob?
> >
> > this not work:
> > dw_1.Object.Data[ 1, 7]
> >
> > thanks.
> >
> >
>
>