Select first 1 * from sometable works.
Select first 1 * from v_someview fails:

< PREPARE ERROR:
ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 6
,

STATEMENT:
TIBOInternalDataset:
"<TIB_Session>.<TIBOQuery>.<TIBOInternalDataset>."

The view is based on the table, and works fine if I don't have 'FIRST
1'.

Rick DeBay
Senior Software Developer
RxStrategies.net