PBDR.COM

About   -   Contact   -   Purchase   -   Search   -   What's New

 
 
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' )

 

Top of Page

Legal Notice

Ken Howe 2011