Subject | Re: [firebird-support] select first fails with view |
---|---|
Author | Helen Borrie |
Post date | 2004-08-03T23:47:53Z |
At 12:23 PM 3/08/2004 -0400, you wrote:
sixth position of line 3, where the DSQL parser expects to see something else.
SELECT FIRST 1 * FROM PHONE_LIST
/heLen
>Select first 1 * from sometable works.This error message tells you that your SQL statement has a comma at the
>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
> ,
sixth position of line 3, where the DSQL parser expects to see something else.
> STATEMENT:In the Employee database, PHONE_LIST is a view, and this works fine:
> TIBOInternalDataset:
>"<TIB_Session>.<TIBOQuery>.<TIBOInternalDataset>."
>
>The view is based on the table, and works fine if I don't have 'FIRST
>1'.
SELECT FIRST 1 * FROM PHONE_LIST
/heLen