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.

SELECTBLOB and UPDATEBLOB

2 posts in Appeon (partner product) Last posting was on 2008-06-30 14:00:36.0Z
Chris Posted on 2008-06-26 17:34:06.0Z
From: Chris <cmetalic@gmail.com>
Newsgroups: sybase.public.appeon
Subject: SELECTBLOB and UPDATEBLOB
Date: Thu, 26 Jun 2008 10:34:06 -0700 (PDT)
Organization: http://groups.google.com
Lines: 22
Message-ID: <6d1237fd-c2cd-4935-8ffa-af8543bebf62@f63g2000hsf.googlegroups.com>
NNTP-Posting-Host: 192.85.37.96
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1214501646 17941 127.0.0.1 (26 Jun 2008 17:34:06 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 26 Jun 2008 17:34:06 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f63g2000hsf.googlegroups.com; posting-host=192.85.37.96; posting-account=9m3qFAoAAACMZc-bJgOV727WMHBNHILK
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!f63g2000hsf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2165
Article PK: 21557

What's the capability of using these statements (SELECTBLOB,
UPDATEBLOB)? I've read mixed
directions concerning their usage, in one place in the doco, it
indicates that it is supported, in another not. I'm still using
Appeon 5.5 (hope to upgrade this week) with Oracle 10g. Here's my PB
code. Any reason why this won't work (and any help at how to
workaround)? I'm getting the message from the 'else' statement as my
result, and I know I've got data in the field (since it works for
client/server).

blob ib_docdata

selectblob report_tx into :ib_docdata from child_report_doc where
report_id = 1;
if sqlca.sqldbcode <> 0 then
messagebox("sql",sqlca.sqlerrtext)
elseif len(ib_docdata) > 0 then
ole_tx1.object.loadfrommemory(ib_docdata,9) // load from blob
- works in C/S, not Appeon
else
Messagebox("blob", "not retrieved")
end if


Sally Li Posted on 2008-06-30 14:00:36.0Z
Sender: 4d74.4868d741.1804289383@sybase.com
From: Sally Li
Newsgroups: sybase.public.appeon
Subject: Re: SELECTBLOB and UPDATEBLOB
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4868e704.512b.1681692777@sybase.com>
References: <6d1237fd-c2cd-4935-8ffa-af8543bebf62@f63g2000hsf.googlegroups.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Jun 2008 07:00:36 -0700
X-Trace: forums-1-dub 1214834436 10.22.241.41 (30 Jun 2008 07:00:36 -0700)
X-Original-Trace: 30 Jun 2008 07:00:36 -0700, 10.22.241.41
Lines: 49
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2168
Article PK: 21552

Hi Chris,

Regarding to the mixed information in Appeon Help. This is
becuase there are two Appeon deployment modes, one is Appeon
Xcelerator deployment mode and the other is Appeon
Pure-JavaScript deployment mode, and the supported status
for each feature might be different in different deployment
mode. So when you search a feature, make sure you are
reading the information in the correct location. Yon can
check the location of the inforamtion in "Location" column
in Appeon Help Search tab page.
For Appoen Xcelerator deployment, both SELECTBLOB and
UPDATEBLOB are supported.

As for the error, the problem should be caused by the code
"ole_tx1.object.loadfrommemory(ib_docdata,9)", please try to
use OLECusotmControl to replace the OLEControl to work
around this issue.

BTW, APB 5.5 is an aborted version. The latest Appeon
version is APB 6.0 and it has been released for a while. You
can contact Appeon Sales for a trial copy of APB 6.0.

Regards
Sally

> What's the capability of using these statements
> (SELECTBLOB, UPDATEBLOB)? I've read mixed
> directions concerning their usage, in one place in the
> doco, it indicates that it is supported, in another not.
> I'm still using Appeon 5.5 (hope to upgrade this week)
> with Oracle 10g. Here's my PB code. Any reason why this
> won't work (and any help at how to workaround)? I'm
> getting the message from the 'else' statement as my result
> , and I know I've got data in the field (since it works
> for client/server).
>
> blob ib_docdata
>
> selectblob report_tx into :ib_docdata from
> child_report_doc where report_id = 1;
> if sqlca.sqldbcode <> 0 then
> messagebox("sql",sqlca.sqlerrtext)
> elseif len(ib_docdata) > 0 then
> ole_tx1.object.loadfrommemory(ib_docdata,9) //
> load from blob - works in C/S, not Appeon
> else
> Messagebox("blob", "not retrieved")
> end if