(BTW.. I am sorry about posting this message on Firebird general.)

This statement will not work for a VIEW:

select first 10 start_price, title, BEECOM_ITEM_ID from vendor_item
order by beecom_item_id DESCENDING;


Here is the error:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 5, char 8.
first.