Helen Borrie schrieb:

> At 12:23 PM 3/08/2004 -0400, you wrote:
>
>>Select first 1 * from sometable works.
>>Select first 1 * from v_someview fails:

> In the Employee database, PHONE_LIST is a view, and this works fine:
>
> SELECT FIRST 1 * FROM PHONE_LIST

Not quite.
Working with an IB_Query (4.2Hf) some statements work, some don't.

SELECT FIRST 1 * FROM VIEW ... does NOT work
while:
SELECT FIRST 1 <FIELDLIST> does work!

The same query with DBWorkbench (with a more recent IBO-Version) does
work in both cases!


Luc.