Hi,
You do have an extra single quote just before the closing bracket:
where put(id,8.) in("&id_list."');
You might not need to perform any conversions or use any quotes. Have you tried something like:
where id in (&id_list.);
If you really want quotes around the values in your list then when you use SQL to create the list then you could try using the quote() function, e.g.:
select quote(cats(id)) into :id_list separated by ','
As quote() requires a string I also used the cats() function to convert id to a string and then strip the result of leading and trailing spaces.
Try displaying the result of your put() conversion and you might find you have leading spaces which could reduce the chances of finding a match in the list. Also display the value of &id_list to make sure it looks like what you expect.
Kind regards,
Amir.
Edited for typo and formatting.
... View more