Pb12.6 environment, needs based on array contents dynamically changing data window,
Code:
Old_select=dw_1. GetSQLSelect ()
String shuzu [500]
Array shuzu assignment just
New_select=old_select + 'where pid (: shuzu) in'
Dw_1. SetSQLSelect (new_select)
Dw_1. Settrans (sqlca)
Dw_1. Retrieve (shuzu)

Error message is:
Select Error: SQLSTATE=37000
[Microsoft] [ODBC SQL Server Driver] [SQL Server] ':' near a syntax error,