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.

DW array of decimals as a retrieval argument.

9 posts in DataWindow Last posting was on 2008-05-15 16:17:00.0Z
Damien Posted on 2008-05-14 09:26:27.0Z
From: Damien <nospam.c.mortall@recursor.net>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: DW array of decimals as a retrieval argument.
Date: Wed, 14 May 2008 02:26:27 -0700 (PDT)
Organization: http://groups.google.com
Lines: 32
Message-ID: <47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com>
NNTP-Posting-Host: 167.127.24.25
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1210757188 1853 127.0.0.1 (14 May 2008 09:26:28 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 14 May 2008 09:26:28 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: 25g2000hsx.googlegroups.com; posting-host=167.127.24.25; posting-account=FeHn4AoAAAAE9yobD2kEEDn-2KDDWbig
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 IE IE 6.0,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 ntni-ext-cache1 (NetCache NetApp/6.0.2), 1.1 ho-ext-cache1 (NetCache NetApp/6.0.6)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!newscon02.news.prodigy.net!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!25g2000hsx.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86834
Article PK: 416093

Hi All,

I am having problems with dw.retrieve method.
What I want is to pass an unbounded array of decimals to the retrieve
method.
(I checked with bounded array and it did not work either.)

I defined dw argument as numberarray:
arguments=((" aldc_pids ", numberlist))
A dw query seems to be correct as well:
WHERE pid in (:aldc_pids)

And code fragments from my scripts:
decimal{0} ldc_pids[]
[…]
rc = inv_audit.Retrieve(ldc_pids)

rc always equals -1.

I was passing arrays of numbers to a datawindow before and it worked
just fine.
Are there any known issues with decimals?

It works when I pass a single decimal value. For example: ldc_pids[1].

The second option for me is to modify where clause dynamically, but
this won’t be as easy and elegant as the array solution.

Thanks in advance,
Damien

I am using PB9.03 build 8784, DB2 and ODBC.


Chris Pollach Posted on 2008-05-14 11:43:55.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com>
Subject: Re: DW array of decimals as a retrieval argument.
Lines: 43
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.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <482ad07b$1@forums-1-dub>
Date: 14 May 2008 04:43:55 -0700
X-Trace: forums-1-dub 1210765435 10.22.241.152 (14 May 2008 04:43:55 -0700)
X-Original-Trace: 14 May 2008 04:43:55 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86835
Article PK: 416094

Damien;

What type of error(s) do you get and where?

Thanks ... Chris


"Damien" <nospam.c.mortall@recursor.net> wrote in message
news:47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com...
Hi All,

I am having problems with dw.retrieve method.
What I want is to pass an unbounded array of decimals to the retrieve
method.
(I checked with bounded array and it did not work either.)

I defined dw argument as numberarray:
arguments=((" aldc_pids ", numberlist))
A dw query seems to be correct as well:
WHERE pid in (:aldc_pids)

And code fragments from my scripts:
decimal{0} ldc_pids[]
[…]
rc = inv_audit.Retrieve(ldc_pids)

rc always equals -1.

I was passing arrays of numbers to a datawindow before and it worked
just fine.
Are there any known issues with decimals?

It works when I pass a single decimal value. For example: ldc_pids[1].

The second option for me is to modify where clause dynamically, but
this won’t be as easy and elegant as the array solution.

Thanks in advance,
Damien

I am using PB9.03 build 8784, DB2 and ODBC.


Damien Posted on 2008-05-14 13:41:52.0Z
From: Damien <nospam.c.mortall@recursor.net>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: DW array of decimals as a retrieval argument.
Date: Wed, 14 May 2008 06:41:52 -0700 (PDT)
Organization: http://groups.google.com
Lines: 52
Message-ID: <c2e634ce-a477-432b-917c-2a6a39b0a0f9@i76g2000hsf.googlegroups.com>
References: <47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com> <482ad07b$1@forums-1-dub>
NNTP-Posting-Host: 167.127.24.25
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1210772512 13380 127.0.0.1 (14 May 2008 13:41:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 14 May 2008 13:41:52 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: i76g2000hsf.googlegroups.com; posting-host=167.127.24.25; posting-account=FeHn4AoAAAAE9yobD2kEEDn-2KDDWbig
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 IE IE 6.0,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 ntni-ext-cache1 (NetCache NetApp/6.0.2), 1.1 ho-ext-cache1 (NetCache NetApp/6.0.6)
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!i76g2000hsf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86838
Article PK: 416097

Chris,

Retrieve always returns -1. I do not have any specific error message.
Was wondering is it possible to use unbounded array of decimals as a
retrieve parameter. I would think this is possible.

Thanks,
Damien

On May 14, 12:43 pm, "Chris Pollach" <cpoll...@travel-net.com> wrote:
> Damien;
>
> What type of error(s) do you get and where?
>
> Thanks ... Chris
>
> "Damien" <nospam.c.mort...@recursor.net> wrote in message
>
> news:47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com...
> Hi All,
>
> I am having problems with dw.retrieve method.
> What I want is to pass an unbounded array of decimals to the retrieve
> method.
> (I checked with bounded array and it did not work either.)
>
> I defined dw argument as numberarray:
> arguments=((" aldc_pids ", numberlist))
> A dw query seems to be correct as well:
> WHERE pid in (:aldc_pids)
>
> And code fragments from my scripts:
> decimal{0} ldc_pids[]
> […]
> rc = inv_audit.Retrieve(ldc_pids)
>
> rc always equals -1.
>
> I was passing arrays of numbers to a datawindow before and it worked
> just fine.
> Are there any known issues with decimals?
>
> It works when I pass a single decimal value. For example: ldc_pids[1].
>
> The second option for me is to modify where clause dynamically, but
> this won’t be as easy and elegant as the array solution.
>
> Thanks in advance,
> Damien
>
> I am using PB9.03 build 8784, DB2 and ODBC.


Damien Posted on 2008-05-14 15:25:50.0Z
From: Damien <nospam.c.mortall@recursor.net>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: DW array of decimals as a retrieval argument.
Date: Wed, 14 May 2008 08:25:50 -0700 (PDT)
Organization: http://groups.google.com
Lines: 66
Message-ID: <e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com>
References: <47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com> <482ad07b$1@forums-1-dub> <c2e634ce-a477-432b-917c-2a6a39b0a0f9@i76g2000hsf.googlegroups.com>
NNTP-Posting-Host: 167.127.24.25
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1210778750 8109 127.0.0.1 (14 May 2008 15:25:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 14 May 2008 15:25:50 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: 34g2000hsf.googlegroups.com; posting-host=167.127.24.25; posting-account=FeHn4AoAAAAE9yobD2kEEDn-2KDDWbig
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 IE IE 6.0,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 ntni-ext-cache1 (NetCache NetApp/6.0.2), 1.1 ho-ext-cache1 (NetCache NetApp/6.0.6)
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!34g2000hsf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86841
Article PK: 416100

Problem solved.

Someone overwritten one of the underlying data sources I am sharing
data with.
You do not want to know what I do to this person when I find him ;)

Thanks for looking at this Chris.
I must be tired I did not notice this before.

Regards
Damien

On May 14, 2:41 pm, Damien <nospam.c.mort...@recursor.net> wrote:
> Chris,
>
> Retrieve always returns -1. I do not have any specific error message.
> Was wondering is it possible to use unbounded array of decimals as a
> retrieve parameter. I would think this is possible.
>
> Thanks,
> Damien
>
> On May 14, 12:43 pm, "Chris Pollach" <cpoll...@travel-net.com> wrote:
>
> > Damien;
>
> > What type of error(s) do you get and where?
>
> > Thanks ... Chris
>
> > "Damien" <nospam.c.mort...@recursor.net> wrote in message
>
> >news:47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com...
> > Hi All,
>
> > I am having problems with dw.retrieve method.
> > What I want is to pass an unbounded array of decimals to the retrieve
> > method.
> > (I checked with bounded array and it did not work either.)
>
> > I defined dw argument as numberarray:
> > arguments=((" aldc_pids ", numberlist))
> > A dw query seems to be correct as well:
> > WHERE pid in (:aldc_pids)
>
> > And code fragments from my scripts:
> > decimal{0} ldc_pids[]
> > […]
> > rc = inv_audit.Retrieve(ldc_pids)
>
> > rc always equals -1.
>
> > I was passing arrays of numbers to a datawindow before and it worked
> > just fine.
> > Are there any known issues with decimals?
>
> > It works when I pass a single decimal value. For example: ldc_pids[1].
>
> > The second option for me is to modify where clause dynamically, but
> > this won’t be as easy and elegant as the array solution.
>
> > Thanks in advance,
> > Damien
>
> > I am using PB9.03 build 8784, DB2 and ODBC.


Chris Pollach Posted on 2008-05-14 16:15:03.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com> <482ad07b$1@forums-1-dub> <c2e634ce-a477-432b-917c-2a6a39b0a0f9@i76g2000hsf.googlegroups.com> <e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com>
Subject: Re: DW array of decimals as a retrieval argument.
Lines: 73
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <482b1007$1@forums-1-dub>
Date: 14 May 2008 09:15:03 -0700
X-Trace: forums-1-dub 1210781703 10.22.241.152 (14 May 2008 09:15:03 -0700)
X-Original-Trace: 14 May 2008 09:15:03 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86842
Article PK: 416101

Been there, done that, do not want to be back there any time soon either!
PS: Try the FindAProgrammer GPS locator. :-)

"Damien" <nospam.c.mortall@recursor.net> wrote in message
news:e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com...
Problem solved.

Someone overwritten one of the underlying data sources I am sharing
data with.
You do not want to know what I do to this person when I find him ;)

Thanks for looking at this Chris.
I must be tired I did not notice this before.

Regards
Damien

On May 14, 2:41 pm, Damien <nospam.c.mort...@recursor.net> wrote:
> Chris,
>
> Retrieve always returns -1. I do not have any specific error message.
> Was wondering is it possible to use unbounded array of decimals as a
> retrieve parameter. I would think this is possible.
>
> Thanks,
> Damien
>
> On May 14, 12:43 pm, "Chris Pollach" <cpoll...@travel-net.com> wrote:
>
> > Damien;
>
> > What type of error(s) do you get and where?
>
> > Thanks ... Chris
>
> > "Damien" <nospam.c.mort...@recursor.net> wrote in message
>
> >news:47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com...
> > Hi All,
>
> > I am having problems with dw.retrieve method.
> > What I want is to pass an unbounded array of decimals to the retrieve
> > method.
> > (I checked with bounded array and it did not work either.)
>
> > I defined dw argument as numberarray:
> > arguments=((" aldc_pids ", numberlist))
> > A dw query seems to be correct as well:
> > WHERE pid in (:aldc_pids)
>
> > And code fragments from my scripts:
> > decimal{0} ldc_pids[]
> > […]
> > rc = inv_audit.Retrieve(ldc_pids)
>
> > rc always equals -1.
>
> > I was passing arrays of numbers to a datawindow before and it worked
> > just fine.
> > Are there any known issues with decimals?
>
> > It works when I pass a single decimal value. For example: ldc_pids[1].
>
> > The second option for me is to modify where clause dynamically, but
> > this won’t be as easy and elegant as the array solution.
>
> > Thanks in advance,
> > Damien
>
> > I am using PB9.03 build 8784, DB2 and ODBC.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-05-14 21:11:54.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com> <482ad07b$1@forums-1-dub> <c2e634ce-a477-432b-917c-2a6a39b0a0f9@i76g2000hsf.googlegroups.com> <e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com> <482b1007$1@forums-1-dub>
Subject: Re: DW array of decimals as a retrieval argument.
Lines: 79
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.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <482b559a@forums-1-dub>
Date: 14 May 2008 14:11:54 -0700
X-Trace: forums-1-dub 1210799514 10.22.241.152 (14 May 2008 14:11:54 -0700)
X-Original-Trace: 14 May 2008 14:11:54 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86845
Article PK: 416103

You mean the news.job_postings section???

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:482b1007$1@forums-1-dub...
>
> Been there, done that, do not want to be back there any time soon either!
> PS: Try the FindAProgrammer GPS locator. :-)
>
> "Damien" <nospam.c.mortall@recursor.net> wrote in message
> news:e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com...
> Problem solved.
>
> Someone overwritten one of the underlying data sources I am sharing
> data with.
> You do not want to know what I do to this person when I find him ;)
>
> Thanks for looking at this Chris.
> I must be tired I did not notice this before.
>
> Regards
> Damien
>
> On May 14, 2:41 pm, Damien <nospam.c.mort...@recursor.net> wrote:
>> Chris,
>>
>> Retrieve always returns -1. I do not have any specific error message.
>> Was wondering is it possible to use unbounded array of decimals as a
>> retrieve parameter. I would think this is possible.
>>
>> Thanks,
>> Damien
>>
>> On May 14, 12:43 pm, "Chris Pollach" <cpoll...@travel-net.com> wrote:
>>
>> > Damien;
>>
>> > What type of error(s) do you get and where?
>>
>> > Thanks ... Chris
>>
>> > "Damien" <nospam.c.mort...@recursor.net> wrote in message
>>
>> >news:47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com...
>> > Hi All,
>>
>> > I am having problems with dw.retrieve method.
>> > What I want is to pass an unbounded array of decimals to the retrieve
>> > method.
>> > (I checked with bounded array and it did not work either.)
>>
>> > I defined dw argument as numberarray:
>> > arguments=((" aldc_pids ", numberlist))
>> > A dw query seems to be correct as well:
>> > WHERE pid in (:aldc_pids)
>>
>> > And code fragments from my scripts:
>> > decimal{0} ldc_pids[]
>> > [.]
>> > rc = inv_audit.Retrieve(ldc_pids)
>>
>> > rc always equals -1.
>>
>> > I was passing arrays of numbers to a datawindow before and it worked
>> > just fine.
>> > Are there any known issues with decimals?
>>
>> > It works when I pass a single decimal value. For example: ldc_pids[1].
>>
>> > The second option for me is to modify where clause dynamically, but
>> > this won't be as easy and elegant as the array solution.
>>
>> > Thanks in advance,
>> > Damien
>>
>> > I am using PB9.03 build 8784, DB2 and ODBC.
>
>


Chris Pollach Posted on 2008-05-15 12:08:06.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com> <482ad07b$1@forums-1-dub> <c2e634ce-a477-432b-917c-2a6a39b0a0f9@i76g2000hsf.googlegroups.com> <e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com> <482b1007$1@forums-1-dub> <482b559a@forums-1-dub>
Subject: Re: DW array of decimals as a retrieval argument.
Lines: 89
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.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <482c27a6$1@forums-1-dub>
Date: 15 May 2008 05:08:06 -0700
X-Trace: forums-1-dub 1210853286 10.22.241.152 (15 May 2008 05:08:06 -0700)
X-Original-Trace: 15 May 2008 05:08:06 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86848
Article PK: 416106

No .. it was some light levity regarding Damien's plight to find the
programmer who changed the data source definition on his shared DWO's. :-)

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:482b559a@forums-1-dub...
> You mean the news.job_postings section???
>
> "Chris Pollach" <cpollach@travel-net.com> wrote in message
> news:482b1007$1@forums-1-dub...
>>
>> Been there, done that, do not want to be back there any time soon either!
>> PS: Try the FindAProgrammer GPS locator. :-)
>>
>> "Damien" <nospam.c.mortall@recursor.net> wrote in message
>> news:e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com...
>> Problem solved.
>>
>> Someone overwritten one of the underlying data sources I am sharing
>> data with.
>> You do not want to know what I do to this person when I find him ;)
>>
>> Thanks for looking at this Chris.
>> I must be tired I did not notice this before.
>>
>> Regards
>> Damien
>>
>> On May 14, 2:41 pm, Damien <nospam.c.mort...@recursor.net> wrote:
>>> Chris,
>>>
>>> Retrieve always returns -1. I do not have any specific error message.
>>> Was wondering is it possible to use unbounded array of decimals as a
>>> retrieve parameter. I would think this is possible.
>>>
>>> Thanks,
>>> Damien
>>>
>>> On May 14, 12:43 pm, "Chris Pollach" <cpoll...@travel-net.com> wrote:
>>>
>>> > Damien;
>>>
>>> > What type of error(s) do you get and where?
>>>
>>> > Thanks ... Chris
>>>
>>> > "Damien" <nospam.c.mort...@recursor.net> wrote in message
>>>
>>> >news:47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com...
>>> > Hi All,
>>>
>>> > I am having problems with dw.retrieve method.
>>> > What I want is to pass an unbounded array of decimals to the retrieve
>>> > method.
>>> > (I checked with bounded array and it did not work either.)
>>>
>>> > I defined dw argument as numberarray:
>>> > arguments=((" aldc_pids ", numberlist))
>>> > A dw query seems to be correct as well:
>>> > WHERE pid in (:aldc_pids)
>>>
>>> > And code fragments from my scripts:
>>> > decimal{0} ldc_pids[]
>>> > [.]
>>> > rc = inv_audit.Retrieve(ldc_pids)
>>>
>>> > rc always equals -1.
>>>
>>> > I was passing arrays of numbers to a datawindow before and it worked
>>> > just fine.
>>> > Are there any known issues with decimals?
>>>
>>> > It works when I pass a single decimal value. For example: ldc_pids[1].
>>>
>>> > The second option for me is to modify where clause dynamically, but
>>> > this won't be as easy and elegant as the array solution.
>>>
>>> > Thanks in advance,
>>> > Damien
>>>
>>> > I am using PB9.03 build 8784, DB2 and ODBC.
>>
>>
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-05-15 14:30:35.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com> <482ad07b$1@forums-1-dub> <c2e634ce-a477-432b-917c-2a6a39b0a0f9@i76g2000hsf.googlegroups.com> <e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com> <482b1007$1@forums-1-dub> <482b559a@forums-1-dub> <482c27a6$1@forums-1-dub>
Subject: Re: DW array of decimals as a retrieval argument.
Lines: 98
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <482c490b$1@forums-1-dub>
Date: 15 May 2008 07:30:35 -0700
X-Trace: forums-1-dub 1210861835 10.22.241.152 (15 May 2008 07:30:35 -0700)
X-Original-Trace: 15 May 2008 07:30:35 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86851
Article PK: 416108

Well, after he finds that programmer he will surely require a sucessor ;-)

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:482c27a6$1@forums-1-dub...
>
> No .. it was some light levity regarding Damien's plight to find the
> programmer who changed the data source definition on his shared DWO's.
> :-)
>
>
>
> "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
> news:482b559a@forums-1-dub...
>> You mean the news.job_postings section???
>>
>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>> news:482b1007$1@forums-1-dub...
>>>
>>> Been there, done that, do not want to be back there any time soon
>>> either!
>>> PS: Try the FindAProgrammer GPS locator. :-)
>>>
>>> "Damien" <nospam.c.mortall@recursor.net> wrote in message
>>> news:e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com...
>>> Problem solved.
>>>
>>> Someone overwritten one of the underlying data sources I am sharing
>>> data with.
>>> You do not want to know what I do to this person when I find him ;)
>>>
>>> Thanks for looking at this Chris.
>>> I must be tired I did not notice this before.
>>>
>>> Regards
>>> Damien
>>>
>>> On May 14, 2:41 pm, Damien <nospam.c.mort...@recursor.net> wrote:
>>>> Chris,
>>>>
>>>> Retrieve always returns -1. I do not have any specific error message.
>>>> Was wondering is it possible to use unbounded array of decimals as a
>>>> retrieve parameter. I would think this is possible.
>>>>
>>>> Thanks,
>>>> Damien
>>>>
>>>> On May 14, 12:43 pm, "Chris Pollach" <cpoll...@travel-net.com> wrote:
>>>>
>>>> > Damien;
>>>>
>>>> > What type of error(s) do you get and where?
>>>>
>>>> > Thanks ... Chris
>>>>
>>>> > "Damien" <nospam.c.mort...@recursor.net> wrote in message
>>>>
>>>> >news:47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com...
>>>> > Hi All,
>>>>
>>>> > I am having problems with dw.retrieve method.
>>>> > What I want is to pass an unbounded array of decimals to the retrieve
>>>> > method.
>>>> > (I checked with bounded array and it did not work either.)
>>>>
>>>> > I defined dw argument as numberarray:
>>>> > arguments=((" aldc_pids ", numberlist))
>>>> > A dw query seems to be correct as well:
>>>> > WHERE pid in (:aldc_pids)
>>>>
>>>> > And code fragments from my scripts:
>>>> > decimal{0} ldc_pids[]
>>>> > [.]
>>>> > rc = inv_audit.Retrieve(ldc_pids)
>>>>
>>>> > rc always equals -1.
>>>>
>>>> > I was passing arrays of numbers to a datawindow before and it worked
>>>> > just fine.
>>>> > Are there any known issues with decimals?
>>>>
>>>> > It works when I pass a single decimal value. For example:
>>>> > ldc_pids[1].
>>>>
>>>> > The second option for me is to modify where clause dynamically, but
>>>> > this won't be as easy and elegant as the array solution.
>>>>
>>>> > Thanks in advance,
>>>> > Damien
>>>>
>>>> > I am using PB9.03 build 8784, DB2 and ODBC.
>>>
>>>
>>
>>
>
>


Chris Pollach Posted on 2008-05-15 16:17:00.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com> <482ad07b$1@forums-1-dub> <c2e634ce-a477-432b-917c-2a6a39b0a0f9@i76g2000hsf.googlegroups.com> <e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com> <482b1007$1@forums-1-dub> <482b559a@forums-1-dub> <482c27a6$1@forums-1-dub> <482c490b$1@forums-1-dub>
Subject: Re: DW array of decimals as a retrieval argument.
Lines: 107
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.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <482c61fc$1@forums-1-dub>
Date: 15 May 2008 09:17:00 -0700
X-Trace: forums-1-dub 1210868220 10.22.241.152 (15 May 2008 09:17:00 -0700)
X-Original-Trace: 15 May 2008 09:17:00 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86853
Article PK: 416111

Hmm .. I smell a job opportunity - ROFL!

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:482c490b$1@forums-1-dub...
> Well, after he finds that programmer he will surely require a sucessor ;-)
>
> "Chris Pollach" <cpollach@travel-net.com> wrote in message
> news:482c27a6$1@forums-1-dub...
>>
>> No .. it was some light levity regarding Damien's plight to find the
>> programmer who changed the data source definition on his shared DWO's.
>> :-)
>>
>>
>>
>> "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
>> news:482b559a@forums-1-dub...
>>> You mean the news.job_postings section???
>>>
>>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>>> news:482b1007$1@forums-1-dub...
>>>>
>>>> Been there, done that, do not want to be back there any time soon
>>>> either!
>>>> PS: Try the FindAProgrammer GPS locator. :-)
>>>>
>>>> "Damien" <nospam.c.mortall@recursor.net> wrote in message
>>>> news:e74b4167-3bb1-452a-a74d-7d6a7029dada@34g2000hsf.googlegroups.com...
>>>> Problem solved.
>>>>
>>>> Someone overwritten one of the underlying data sources I am sharing
>>>> data with.
>>>> You do not want to know what I do to this person when I find him ;)
>>>>
>>>> Thanks for looking at this Chris.
>>>> I must be tired I did not notice this before.
>>>>
>>>> Regards
>>>> Damien
>>>>
>>>> On May 14, 2:41 pm, Damien <nospam.c.mort...@recursor.net> wrote:
>>>>> Chris,
>>>>>
>>>>> Retrieve always returns -1. I do not have any specific error message.
>>>>> Was wondering is it possible to use unbounded array of decimals as a
>>>>> retrieve parameter. I would think this is possible.
>>>>>
>>>>> Thanks,
>>>>> Damien
>>>>>
>>>>> On May 14, 12:43 pm, "Chris Pollach" <cpoll...@travel-net.com> wrote:
>>>>>
>>>>> > Damien;
>>>>>
>>>>> > What type of error(s) do you get and where?
>>>>>
>>>>> > Thanks ... Chris
>>>>>
>>>>> > "Damien" <nospam.c.mort...@recursor.net> wrote in message
>>>>>
>>>>> >news:47820c23-cd35-4b9b-a8cb-2e9bdd4b0e4f@25g2000hsx.googlegroups.com...
>>>>> > Hi All,
>>>>>
>>>>> > I am having problems with dw.retrieve method.
>>>>> > What I want is to pass an unbounded array of decimals to the
>>>>> > retrieve
>>>>> > method.
>>>>> > (I checked with bounded array and it did not work either.)
>>>>>
>>>>> > I defined dw argument as numberarray:
>>>>> > arguments=((" aldc_pids ", numberlist))
>>>>> > A dw query seems to be correct as well:
>>>>> > WHERE pid in (:aldc_pids)
>>>>>
>>>>> > And code fragments from my scripts:
>>>>> > decimal{0} ldc_pids[]
>>>>> > [.]
>>>>> > rc = inv_audit.Retrieve(ldc_pids)
>>>>>
>>>>> > rc always equals -1.
>>>>>
>>>>> > I was passing arrays of numbers to a datawindow before and it worked
>>>>> > just fine.
>>>>> > Are there any known issues with decimals?
>>>>>
>>>>> > It works when I pass a single decimal value. For example:
>>>>> > ldc_pids[1].
>>>>>
>>>>> > The second option for me is to modify where clause dynamically, but
>>>>> > this won't be as easy and elegant as the array solution.
>>>>>
>>>>> > Thanks in advance,
>>>>> > Damien
>>>>>
>>>>> > I am using PB9.03 build 8784, DB2 and ODBC.
>>>>
>>>>
>>>
>>>
>>
>>
>
>