Sage 300 CRE 15.1.36 SQL TOP not working

Hi,
I'm connecting to Sage via an ODBC driver. I have everything working except the use of 'TOP'; 
I get the following error
SQL error: [Simba][SimbaEngine ODBC Driver]SELECT TOP 1<< ??? >> * FROM <Table>, SQL state 37000 in SQLPrepare

Is there a way to limit rows? I see TOP mentioned in a version 16 answer, so my guess is it's supposed to work.

Thanks.

-Don-