Dear all,
Sorry ahead for a really trivial question, but I'm not very familiar
with sqlite and just can't figure it out ...
I'm importing large survey files into sqlite, and I run into the
problem of creating a table with too many columns, i.e.
bash$ sqlite3 < tables.sql
produces
bash$ SQL error near line 3: too many columns on t3
(where tables.sql looks like this: create table t1(var1,var2,...); create
t2(var1, var2, ...); )
Now I figured that I have to change the limit on columns -- see
http://www.sqlite.org/c3ref/c_limit_attached.html
but I don't know how! I tred all kinds of variations of
int sqlite3_limit(sqlite3*, SQLITE_LIMIT_COLUMN, 5000)
as for instance
sqlite> int sqlite3_limit(sqlite3*, SQLITE_LIMIT_COLUMN, 5000);
all without success.
Thanks in advance fr the help -- you'll do me a big favor.
Stephan
--
-----------------------
Stephan Lindner
University of Michigan
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
