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


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com