Retrieve with an Array of Arguments
If you are using SQL in your datawindow to retrieve your data you can retrieve a list of records by passing an array of keys as a retrieval argument.

PowerBuilder will replace the argument in the SQL with a list of arguments. You need to modify your where clause to use the IN clause:

WHERE user_id IN ( :as_userids )

At runtime would become:

WHERE user_id IN ( 'ken', 'howe' )

Back