>Hi Bob
>I never used PB to any extent, so I am just curious, does PB support macro substitution (like in: cSelect = "SELECT...", &cSelect) ?
>Alex.

I am not 100% sure, but, due to that fact that PB has strict data typing, you must declare a variable type (of course you can declare it as ANY), I am going to say no... but, you can combine your embeded SQL with variables, like...

SELECT emp_id, salary INTO :li_emp :ldc_pay from
EMPLOYEE where emp_id = :li_which_emp using SQLCA;

All the things that start with : are PB variables.

BOb