No commas are in the query, although they are in the view definition.
The view definition is valid and can be queried.

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Tuesday, August 03, 2004 7:48 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] select first fails with view

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





Yahoo! Groups Links