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

Reply via email to