I am using sql pass-through for remote access to a sybase database.

My select statements are developed by storing the statement to a variable and passing this variable to the sqlexec statement with macro substitution.

i.e.
sqlkey="1"
sqlselect="Select * from loan_information for loan_id="+sqlkey"
=sqlexec('&sqlselect','info')


This seems to work fine until my select statement gets longer than 254 characters. (the max lingth of a string.

Does anyone have an idea or an example of a long select statement using sql pass-through.

Thanks