Re: powerbuilder unable to send more than 1000 elements in the number array - dw parameter

quoth steelbird_at_hotmail.com (chandran) :

>hi all,
>
>i have gone through the postings, but still could not find a
>satisfactory reason.
>
>am using :
>powerbuilder 7.02 + oracle 8.1.5
>
>my doubt is :
>my datawindow works fine till it has around 950 elements (a long
>array)
>when i have more, the retrieve returns -1.
>eg:
>select * from table_a where id in (:l_var);
>
>i found from the powerbuilder newsgroups that this is specific to
>Database vendor. what parameter in the Oracle should i redefine to
>increase or support an unlimited number or elements in the "IN CLAUSE
>"

Probably some limit on the size of the SQL statement.

An alternative might be to index the field, do one retrieve, and filter the results somehow. Maybe with a temp field that you can set to one value based on the selected criteria.

Failing that, you can return 2 in the retrievestart event and cause successive retrieves to be cumulative instead of replacing the dw contents.

Might be better to examine your spec...what sort of app logic requires 950 separate criteria at once, anyway? Received on Mon Sep 23 2002 - 21:44:43 CDT