Re: [GENERAL] How do I change data type from text to bool?

2001-02-20 Thread Brent R. Matzelle
There currently is no simple SQL command that accomplishes this. It can be accomplished by creating an identical new table with the bool data type change and then running a "INSERT INTO new_table (SELECT * FROM old_table)". Then you can check your results, drop the old table, and rename the new

[GENERAL] How do I change data type from text to bool?

2001-02-19 Thread Donald Braman
I have a table/class filled with records/instances in which I accidentally set the fields/attributes data type to text rather than boolean. I now have 75,000 records with 't' and 'f' So now I want to change the attributes to bool? I can't find anything on changing data types in the integrated