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.

Problem with retrieving from datawindow using number array

2 posts in Appeon (partner product) Last posting was on 2005-02-17 11:15:18.0Z
neil Posted on 2005-02-04 03:22:13.0Z
Sender: 1d1c.4202ea01.1804289383@sybase.com
From: neil
Newsgroups: sybase.public.appeon
Subject: Problem with retrieving from datawindow using number array
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4202ea65.1d1e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Feb 2005 19:22:13 -0800
X-Trace: forums-1-dub 1107487333 10.22.241.41 (3 Feb 2005 19:22:13 -0800)
X-Original-Trace: 3 Feb 2005 19:22:13 -0800, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:658
Article PK: 20849

Hi!
I am just wondering what is wrong with my code. These works
well in powerbuilder, but when deployed in appeon problems
occur like for this code, it displays a window asking for a
retrieval argument even though it returns a filled out
report.

open(w_popup_report_e)
w_popup_report_e.dw_1.settransobject(SQLCA)
w_popup_report_e.dw_1.retrieve(pbds[])

Does it have something to do with the argument of type
Number Array that I used? Please advice.

Thanks in advance!

-Neil


Julie Jiang Posted on 2005-02-17 11:15:18.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <4202ea65.1d1e.1681692777@sybase.com>
Subject: Re: Problem with retrieving from datawindow using number array
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: 210.21.221.178
Message-ID: <42147cbb@forums-2-dub>
X-Original-Trace: 17 Feb 2005 03:15:07 -0800, 210.21.221.178
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Feb 2005 03:15:12 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Feb 2005 03:15:18 -0800
X-Trace: forums-1-dub 1108638918 10.22.108.75 (17 Feb 2005 03:15:18 -0800)
X-Original-Trace: 17 Feb 2005 03:15:18 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:672
Article PK: 12649

Hi Neil,

Please try the following and see whether it helps:
1) Get the SQL syntax of the DataWindow
2) If the SQL syntax contains an ARRAY argument as following:
INT ARRAY_A[]
select A.ID,A.NAME FROM TABLE A WHERE A.ID IN (:ARRAY_A);
We suggest you change it to:
int i
ls_sql = "select A.ID,A.NAME FROM TABLE A"
for i = 1 to UpperBound(ARRAY_A)
if i = 1 then
ls_sql = ls_sql + " WHERE A.ID = :"+string(ARRAY_A[I])
else
ls_sql = ls_sql + " OR A.ID = :"+string(ARRAY_A[I])
end if
next
3) After the modification, call the SetSQLSelect to apply the new SQL syntax
to the DataWindow
4) Retest.

If it does not work well, please provide the error screenshot, and the
DataWindow SRD file to me (send to my email address), so that our engineer
can understand better about the case.

Regards,
Julie

<neil> wrote in message news:4202ea65.1d1e.1681692777@sybase.com...
> Hi!
> I am just wondering what is wrong with my code. These works
> well in powerbuilder, but when deployed in appeon problems
> occur like for this code, it displays a window asking for a
> retrieval argument even though it returns a filled out
> report.
>
> open(w_popup_report_e)
> w_popup_report_e.dw_1.settransobject(SQLCA)
> w_popup_report_e.dw_1.retrieve(pbds[])
>
> Does it have something to do with the argument of type
> Number Array that I used? Please advice.
>
> Thanks in advance!
>
> -Neil