Hi!

>Mark:
> If I have the following statement:
>
>lcSQL = "Select clClientID from CLIENTTYPE where clClientID = '" + lcID + "'"

Try:
lcSQL = "Select clClientID from CLIENTTYPE where clClientID = ?m.client_id"

Than run the rest code that you described, it should run correct.

>
>can I then use this command:
>
>sqlexec(gnconn,lcSql,"mycursor")
>
>when I do that it returns empty set, but if put the sql statement in SQLEXEC then it works. My extact codes are:
>m.client_id = TEST.CLIENT
>clSQL = init_val.sql_str
>sqlexec(gnconn,lcSql,"mycursor")
>I tried to put alltrim around init_val.sql_str, it did not work. I copied the content from init_val.sql_str and pasted in the SQLEXEC. It works. any idea on that? thanks
>sherry