#33 move field positions

[Anonymous]

This is an Interbase Bug, incongruence between
documentation and ALTER TABLE STATEMENT

POSITION 1 is documented (Interbase 6 documentation)
as the first position (like order by clause), but the
implementation is that POSITION 0 is the first
position.

Firebird has corrected this bug, if you confirm that
Interbase 6.5 version has POSITION 0 as the first
field then I will ask for version (Interbase and
Firebird) and use
ALTER TABLE .... POSITION 0
Instead of
ALTER TABLE .... POSITION 1
In Interbase versions.

Please, post this bug to sourceforge and also post my
comments so we will track this issue.

In Firebird servers this option is working ok, and
it's possible that works ok also in Interbase 6.5.

Thanks
----- Original Message -----
From: RSoft (tin)
To: toni@pala.com
Sent: Monday, January 14, 2002 1:51 PM
Subject: IBAccess

Hello Dr Toni.

I have found this on version 1.12 and also in 1.15
(the version 1.0 is ok, no bug):
When i try to modify the order of fields in a
table ... the UP arrow don't work ... and the DOWN
arrow move the field in the last position

My platform is:
W98SE
Interbase 6 version WI-V6.0.0.627

Excuse for poor english

Bye
Roberto

[Marand]

Logged In: YES
user_id=4775

I noticed something similar although not exactly identical. Using
IBAccess 1.18 on XP, I try to reorder fields on a table.
- on a FB1.0
server, all works
- on a IB6.5 server (the one provided in D7 Arch.)
-
clicking down moves the field by two rows instead of one, stopping
properly at the bottom of the list
- clicking up does nothing. It *seems*
to perform a movement up by 0 row.

Seems related to the bug
above.