how to use dynamic arguments for in clause for sql for datawindow?
I have datawindow with sql like:
select c1, c2, ... from mytab where id = :arg1.
id is integer.
Then I want to change the query like:
select c1, c2, ... from mytab where id in ( 1, 2, 3)
the number of ID value is dynamic, could be any. in pb code, I can get the string like '1,2,3', but how to set argument for datawindw datassource for this case?
Could you change your datawindow retrieval argument type from 'number' to 'number array', and change '=' to 'IN'?