On 14 Nov 2011, at 7:38am, vinayh4 wrote: > I need to create table with more than 2000 columns, How to reset > SQLITE_MAX_COLUMN value which > is 2000 . Plz help me on this issue.
You almost never need to have more columns than you can fit in your head at one time. The way you handle 2000 columns is to make a database for them ! Have you considered storing your data as triplets: row column value 1 first 234 1 second 54.234 1 third 232.41 ... 2 first 432 2 second 23.413 ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users