At 08:55 AM 4/08/2004 +0200, you wrote:

>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

Oh, that was a pre-Firebird artifact in IBO (4.2Hf came out in June 2002)
that took "FIRST" to be a column identifier and "1" to be a run-time alias,
and would barf when it got to "*". It happened with tables as well as
views. It was fixed later. So maybe this inquirer is working with a
pre-Firebird version of EMS Manager as well. EMS Manager uses FIBPlus, I
think, so the parser in versions since the Firebird 1 release should know
about SELECT FIRST.

It's pretty unlikely to work if EMS is built with IBX, though, since the
IBX parser doesn't know about Firebird features at all.

Here's a fun one for you though:

create table blah (
id integer,
"FIRST" VARCHAR(10));
commit;
insert into blah
values (1, 'parsnips');
insert into blah
values (2, 'turnips');
insert into blah
values (3, 'carrots');
insert into blah
values (4, 'spinach');
commit;

select FIRST from blah;

id FIRST
=== ========
1 parsnips
2 turnips
3 carrots
4 spinach

select FIRST 2 FIRST from blah;

FIRST
========
parsnips
turnips

:-) heLen