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.

IN operator on the data source, Datawindows.

5 posts in DataWindow Last posting was on 2008-08-21 15:42:10.0Z
Alex Posted on 2008-08-20 23:27:40.0Z
Sender: 6910.48aca436.1804289383@sybase.com
From: Alex
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: IN operator on the data source, Datawindows.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48aca86c.69a6.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Aug 2008 16:27:40 -0700
X-Trace: forums-1-dub 1219274860 10.22.241.41 (20 Aug 2008 16:27:40 -0700)
X-Original-Trace: 20 Aug 2008 16:27:40 -0700, 10.22.241.41
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87603
Article PK: 416859

Hi,

I created a DW with the IN operator on a data source, like :

select a,c,b,d where z in :a_argument

when I use the retrieve botom on the dw painter to test the
dw is working, the retrieval argument dialog appear so I put

the valid and tested argument: '002','005'

but doesn't retrieve anything.

So I have trayed whith : 002,005 nothing .
also with '002,005' nothing.

finally

I have copied the syntax from the data source on the ISQL
Session, with the same argument and work fine.


the where in the data source is simple :

"name field in :a_agrument " no other character.

So, please could anyone give me any comment to deal with
this thouble.

TIA

Alex.


Terry Dykstra Posted on 2008-08-21 02:08:58.0Z
From: "Terry Dykstra" <dontreply_tddykstra@forestoil.ca.x>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48aca86c.69a6.1681692777@sybase.com>
Subject: Re: IN operator on the data source, Datawindows.
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48acce3a$1@forums-1-dub>
Date: 20 Aug 2008 19:08:58 -0700
X-Trace: forums-1-dub 1219284538 10.22.241.152 (20 Aug 2008 19:08:58 -0700)
X-Original-Trace: 20 Aug 2008 19:08:58 -0700, vip152.sybase.com
X-Authenticated-User: Teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87605
Article PK: 416861

You need parentheses:

select a,c,b,d where z in ( :a_argument )

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://case-express.sybase.com/cx/welcome.do
http://my.isug.com/index.php?mo=is&op=in

<Alex> wrote in message news:48aca86c.69a6.1681692777@sybase.com...
> Hi,
>
> I created a DW with the IN operator on a data source, like :
>
> select a,c,b,d where z in :a_argument
>
> when I use the retrieve botom on the dw painter to test the
> dw is working, the retrieval argument dialog appear so I put
>
> the valid and tested argument: '002','005'
>
> but doesn't retrieve anything.
>
> So I have trayed whith : 002,005 nothing .
> also with '002,005' nothing.
>
> finally
>
> I have copied the syntax from the data source on the ISQL
> Session, with the same argument and work fine.
>
>
> the where in the data source is simple :
>
> "name field in :a_agrument " no other character.
>
> So, please could anyone give me any comment to deal with
> this thouble.
>
> TIA
>
> Alex.


Alex Posted on 2008-08-21 14:35:18.0Z
Sender: 6910.48aca436.1804289383@sybase.com
From: Alex
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: IN operator on the data source, Datawindows.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48ad7d26.a5e.1681692777@sybase.com>
References: <48acce3a$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 Aug 2008 07:35:18 -0700
X-Trace: forums-1-dub 1219329318 10.22.241.41 (21 Aug 2008 07:35:18 -0700)
X-Original-Trace: 21 Aug 2008 07:35:18 -0700, 10.22.241.41
Lines: 61
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87608
Article PK: 416864

still getting no data

I put parentheses into the where, no data, also try putting
parentheses as part of the retrival argument, nothing.

both situations, fails to retrieve data, I don't know how to
implement the in operator, the right way i meant.
it's confusing.

please some one who can give me an advice.

TIA

Alex.

> You need parentheses:
>
> select a,c,b,d where z in ( :a_argument )
>
> --
> Terry Dykstra (TeamSybase)
> http://powerbuilder.codeXchange.sybase.com/
> http://case-express.sybase.com/cx/welcome.do
> http://my.isug.com/index.php?mo=is&op=in
> <Alex> wrote in message
> > news:48aca86c.69a6.1681692777@sybase.com... Hi,
> >
> > I created a DW with the IN operator on a data source,
> like : >
> > select a,c,b,d where z in :a_argument
> >
> > when I use the retrieve botom on the dw painter to test
> > the dw is working, the retrieval argument dialog appear
> so I put >
> > the valid and tested argument: '002','005'
> >
> > but doesn't retrieve anything.
> >
> > So I have trayed whith : 002,005 nothing .
> > also with '002,005' nothing.
> >
> > finally
> >
> > I have copied the syntax from the data source on the
> > ISQL Session, with the same argument and work fine.
> >
> >
> > the where in the data source is simple :
> >
> > "name field in :a_agrument " no other
> character. >
> > So, please could anyone give me any comment to deal with
> > this thouble.
> >
> > TIA
> >
> > Alex.
>
>


Chris Werner Posted on 2008-08-21 14:43:45.0Z
From: "Chris Werner" <cwAT{PleaseNoSpam}f-s.de>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48acce3a$1@forums-1-dub> <48ad7d26.a5e.1681692777@sybase.com>
Subject: Re: IN operator on the data source, Datawindows.
Lines: 81
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
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: <48ad7f21$1@forums-1-dub>
Date: 21 Aug 2008 07:43:45 -0700
X-Trace: forums-1-dub 1219329825 10.22.241.152 (21 Aug 2008 07:43:45 -0700)
X-Original-Trace: 21 Aug 2008 07:43:45 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87609
Article PK: 416865

Hi Alex,

I use array typed retrieval very often without big problems. The only
one was to find the right "syntax" to fill the retrieval argument dialog
when I retrieve the datawindow in the datawindow painter. So
maybe after fixing the bug (need paranthesis) you haven't tried the
correct syntax (which is '002','005' for string arguments and 002,005
for number arguments I guess). So try that again. Another option is
to check the datawindow directly in tha application, not in the painter
first.

Good luck

Chris Werner
f+s software gmbh


<Alex> schrieb im Newsbeitrag news:48ad7d26.a5e.1681692777@sybase.com...

> still getting no data
>
> I put parentheses into the where, no data, also try putting
> parentheses as part of the retrival argument, nothing.
>
> both situations, fails to retrieve data, I don't know how to
> implement the in operator, the right way i meant.
> it's confusing.
>
> please some one who can give me an advice.
>
> TIA
>
> Alex.
>
>
>
>> You need parentheses:
>>
>> select a,c,b,d where z in ( :a_argument )
>>
>> --
>> Terry Dykstra (TeamSybase)
>> http://powerbuilder.codeXchange.sybase.com/
>> http://case-express.sybase.com/cx/welcome.do
>> http://my.isug.com/index.php?mo=is&op=in
>> <Alex> wrote in message
>> > news:48aca86c.69a6.1681692777@sybase.com... Hi,
>> >
>> > I created a DW with the IN operator on a data source,
>> like : >
>> > select a,c,b,d where z in :a_argument
>> >
>> > when I use the retrieve botom on the dw painter to test
>> > the dw is working, the retrieval argument dialog appear
>> so I put >
>> > the valid and tested argument: '002','005'
>> >
>> > but doesn't retrieve anything.
>> >
>> > So I have trayed whith : 002,005 nothing .
>> > also with '002,005' nothing.
>> >
>> > finally
>> >
>> > I have copied the syntax from the data source on the
>> > ISQL Session, with the same argument and work fine.
>> >
>> >
>> > the where in the data source is simple :
>> >
>> > "name field in :a_agrument " no other
>> character. >
>> > So, please could anyone give me any comment to deal with
>> > this thouble.
>> >
>> > TIA
>> >
>> > Alex.
>>
>>


Alex Posted on 2008-08-21 15:42:10.0Z
Sender: 6910.48aca436.1804289383@sybase.com
From: Alex
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: IN operator on the data source, Datawindows.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48ad8cd2.c77.1681692777@sybase.com>
References: <48ad7f21$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 Aug 2008 08:42:10 -0700
X-Trace: forums-1-dub 1219333330 10.22.241.41 (21 Aug 2008 08:42:10 -0700)
X-Original-Trace: 21 Aug 2008 08:42:10 -0700, 10.22.241.41
Lines: 105
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87611
Article PK: 416867

Finally worked,

I have been using a string type retrieval argunmet, since I
supose what I needed were a string of codes.

But, as you mention, I changed to string array and worked
inmediately.

I feel really gratefull.

Thanks,

Alex.

> Hi Alex,
>
> I use array typed retrieval very often without big
> problems. The only one was to find the right "syntax" to
> fill the retrieval argument dialog when I retrieve the
> datawindow in the datawindow painter. So maybe after
> fixing the bug (need paranthesis) you haven't tried the
> correct syntax (which is '002','005' for string arguments
> and 002,005 for number arguments I guess). So try that
> again. Another option is to check the datawindow directly
> in tha application, not in the painter first.
>
> Good luck
>
> Chris Werner
> f+s software gmbh
>
>
> <Alex> schrieb im Newsbeitrag
> > news:48ad7d26.a5e.1681692777@sybase.com... still getting
> no data >
> > I put parentheses into the where, no data, also try
> > putting parentheses as part of the retrival argument,
> nothing. >
> > both situations, fails to retrieve data, I don't know
> > how to implement the in operator, the right way i meant.
> > it's confusing.
> >
> > please some one who can give me an advice.
> >
> > TIA
> >
> > Alex.
> >
> >
> >
> >> You need parentheses:
> >>
> >> select a,c,b,d where z in ( :a_argument )
> >>
> >> --
> >> Terry Dykstra (TeamSybase)
> >> http://powerbuilder.codeXchange.sybase.com/
> >> http://case-express.sybase.com/cx/welcome.do
> >> http://my.isug.com/index.php?mo=is&op=in
> >> <Alex> wrote in message
> >> > news:48aca86c.69a6.1681692777@sybase.com... Hi,
> >> >
> >> > I created a DW with the IN operator on a data source,
> >> like : >
> >> > select a,c,b,d where z in :a_argument
> >> >
> >> > when I use the retrieve botom on the dw painter to
> test >> > the dw is working, the retrieval argument dialog
> appear >> so I put >
> >> > the valid and tested argument: '002','005'
> >> >
> >> > but doesn't retrieve anything.
> >> >
> >> > So I have trayed whith : 002,005 nothing .
> >> > also with '002,005' nothing.
> >> >
> >> > finally
> >> >
> >> > I have copied the syntax from the data source on the
> >> > ISQL Session, with the same argument and work fine.
> >> >
> >> >
> >> > the where in the data source is simple :
> >> >
> >> > "name field in :a_agrument " no other
> >> character. >
> >> > So, please could anyone give me any comment to deal
> with >> > this thouble.
> >> >
> >> > TIA
> >> >
> >> > Alex.
> >>
> >>
>
>