Hello,

> what is the correct SQL syntax to set the physical position of a field

into

> a table?

You cannot set the _physical_ position. All you get is the _logical_
position.

How things are stored (on disk) cannot be controlled by SQL ...

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com

> I have to change the size of a field so I'm doing:
>
> 1. Creation of a TEMP field
> 2. Copy values of field to change into TEMP
> 3. Drop field to change
> 4. Creation of the field with new size
> 5. Copy of values from TEMP into new field
> 6. Drop field TEMP
>
> At point 4 I'd like to set the position of the new field the same as

before.

> Is it possible?
>
> ALTER TABLE PROVINCES ADD LONG_NAME CH_PROVINCE_LONG_NAME POSITION 3;
>
> This syntax doesn't work, at least into IBExpert.