Re: [sqlite] more than 2000 columns

2011-11-14 Thread vinayh4
for SQLite Table. Thanks Vinay Simon Slavin-3 wrote: > > > 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 al

Re: [sqlite] determine SQLITE_MAX_LENGTH or sql_limit/sqlite3_limit

2011-11-14 Thread vinayh4
ses a large number of columns, you may find that sqlite3_prepare_v2() > runs slowly. > > The maximum number of columns can be lowered at run-time using the > sqlite3_limit(db,SQLITE_LIMIT_COLUMN,size) interface." > > On 11/14/11, vinayh4 <vinay...@gmail.com> wrote: >

Re: [sqlite] determine SQLITE_MAX_LENGTH or sql_limit/sqlite3_limit

2011-11-13 Thread vinayh4
Hi All 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. Thanks Vinay Vannus wrote: > > That should do the trick, thanks for pointing it out. > > On 10 February 2011 06:18, Dan Kennedy