Hi Naomi,

Thanks for the code. However, after following your recommendation, I still don't get anything. After my SELECT-SQL string, I have the SQLGETPROP, SQLSETPROP, SQLEXEC and SQLSETPROP again to query data in our Max Database.

Do I also need to SET NEAR ON before my SELECT string? Please help.

Thanks,
Sam