> -----Original Message-----
> From: Nico Callewaert [mailto:ncw@...]
> Sent: Miércoles 16 de Mayo de 2001 2:42
>
> Hi,
>
> I'm trying to change the position of a field with the
> following command :
>
> "alter table invoice alter coin position 5", but
> the position is not
> changing at all, I'm using Interbase 6. What could be wrong ?

Nico, why do you want to swap a field's position? Do you really want to have
SELECT * FROM <table>
and get the new ordering?

Anyway, let me say that there's a mismatch between what docos say and what
IB does: this command is the only one that uses ZERO-BASED column positions.
To be in sync with SQL, this position should be ONE-based. It was discovered
by a person that maybe is in this list.

C.