26 Mar
2010
26 Mar
'10
12:50 p.m.
Brett Parker wrote:
In case one wasn't aware, all fields in sqlite are text. Nothing else. It doesn't do type checking.
It is not really so simple. Please have a look at http://www.sqlite.org/datatype3.html
For reordering the columns of a table one could resort to a temporary table.
create temporary table temptab as select column4, column3, column2, column1 from sometable;
select * from temptab;
I think that this is more flexible than reordering the columns of the main table. Remember that "temptab" is temporary and lasts only the current session, something I consider a feature.
Govind Chandra