--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@t...> wrote:

> At 07:52 AM 03-07-02 +0000, Alessandro Petrelli wrote:
>
> >Svein,
> >before posting I had the query working correctly with IBExpert 2
> >Personal Edition. I know that IBExpert uses other components for
> >accessing Firebird (FibPlus). So the bug is IBO related.
>
> I don't think so, Alessandro. IB_SQL built in Delphi 6 with IBO

4.2Hf,

> Firebird 1.0 database, dialect 3:
>
> CREATE TABLE AIRCRAFT (
> OID INTEGER NOT NULL
> , REGISTRATION VARCHAR( 8 ) NOT NULL
> , CONSTRAINT PK_AIRCRAFT
> PRIMARY KEY ( OID )
> );
> COMMIT;
>
> insert into aircraft (oid, registration)
> values(1, 'GORILLA');
> insert into aircraft (oid, registration)
> values(2, 'KANGAROO');
> insert into aircraft (oid, registration)
> values(3, 'WOMBAT');
> insert into aircraft (oid, registration)
> values(4, 'TAZTIGER');
>
> COMMIT;
>
> In the Cursor tab:
> select first 1 skip 0 * from AIRCRAFT;
>
> OID REGISTRATION
> ------ --------------------------
> 1 GORILLA
>
> select first 1 skip 0 OID, REGISTRATION from AIRCRAFT;
>
> OID REGISTRATION
> ------ --------------------------
> 1 GORILLA
>
> select first 1 skip 1 OID, REGISTRATION from AIRCRAFT;
>
> OID REGISTRATION
> ------ --------------------------
> 2 KANGAROO
>

Helen,
did you try using parameters and parametrized where conditions as I
described in my first message? The example you posted works
correctly, but mine was different!
If you use a parameter for SKIP and another for a WHERE condition it
will returns 0 rows.

Regards,
Alessandro Petrelli.