Huang Chen Min wrote:
Dear all: Forgive for asking such stupid question. I use Xbase way to understand SQLite. It is allowed to modify dat type of column in clipper. In my personal thoughts, Creating a brandnew table and copy those data from older version might be an alternative way. Is there any instrument to meet my need directly. Best Regards -- tom
You need to study the ALTER TABLE statement and its limitations. See http://www.sqlite.org/lang_altertable.html . Cheers, -- Larry Brasfield _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users