>Accessing AS400 file via Rumba ODBC driver. When I enter the 'select *
> from where = I obtain data.
>But when I replace the with a variable data is not downloaded. Can anybody shed some light as to how to create a SQLEXEC() statement that will process with variables.

Try to pre-prend the variable with a ? mark... I think that may work...

lcSelect = 'select * from table where table.field = ?variable'

BOb