Subject Re: [firebird-support] select first fails with view
Author Helen Borrie
At 12:23 PM 3/08/2004 -0400, you wrote:
>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
> ,

This error message tells you that your SQL statement has a comma at the
sixth position of line 3, where the DSQL parser expects to see something else.


> STATEMENT:
> TIBOInternalDataset:
>"<TIB_Session>.<TIBOQuery>.<TIBOInternalDataset>."
>
>The view is based on the table, and works fine if I don't have 'FIRST
>1'.

In the Employee database, PHONE_LIST is a view, and this works fine:

SELECT FIRST 1 * FROM PHONE_LIST

/heLen