>>I'm not sure, how can I change field's order, using ALTER TABLE.
>
>Oops, sorry, I missed that you were looking for order. How about if you do a SELECT ... INTO TABLE with the appropriate field order, and rename the table when you're done?
The latest probably would help me, however, I've just finished modifing the structure :)
Thanks anyway. I would use SELECT .. INTO techique in a future (though it's still inconvenient to specify 80 fields in one select statement :))
If it's not broken, fix it until it is.
My Blog