|
Home > Archive > SQL Anywhere database > June 2005 > IN list...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Troy Coombs 2005-06-24, 11:24 am |
| In the below example can I not use a string variable that holds the list of
values, for example
ls_id_list = '142, 1596'
so,SELECT *
FROM sales_order
WHERE sales_rep IN (142, 1596)would look like,SELECT *
FROM sales_order
WHERE sales_rep IN (:ls_id_list)It keeps giving me a can not convert to
numeric error. I'm using the a similar SQL statement in a PowerBuilder
datawindow. and want to pass the list in as a retrieval argument.Troy.
| |
| Alex Whitney 2005-06-24, 8:23 pm |
| Needs to be an array of numbers
long ll_list[]
ll_list[1] = 142
ll_list[2] = 1596
SELECT *
FROM sales_order
WHERE sales_rep IN (:ll_list)
Alex
"Troy Coombs" <coombst@quorumis.com> wrote in message
news:42bc33e1$1@foru
ms-2-dub...
> In the below example can I not use a string variable that holds the list
of
> values, for example
> ls_id_list = '142, 1596'
> so,SELECT *
> FROM sales_order
> WHERE sales_rep IN (142, 1596)would look like,SELECT *
> FROM sales_order
> WHERE sales_rep IN (:ls_id_list)It keeps giving me a can not convert to
> numeric error. I'm using the a similar SQL statement in a PowerBuilder
> datawindow. and want to pass the list in as a retrieval argument.Troy.
>
>
|
|
|
|
|