my sqlite3 version is 2.3.2 is it out of date? which version should i install?
-------------------------------------------------- From: "Jay A. Kreibich" <[email protected]> Sent: Tuesday, May 18, 2010 12:30 PM To: "General Discussion of SQLite Database" <[email protected]> Subject: Re: [sqlite] OperationalError: no such function: group_concat > On Tue, May 18, 2010 at 10:31:55AM +0800, zeal scratched on the wall: >> Dear sqlite user group, >> >> i just run a sqlstmt like: >> >>> conn=sqlite3.connect("c:/tmp/tree_db.txt") >> >>> conn.execute("select rdn, group_concat(child_rdn) as child from >> >>> cm_tree group by rdn") >> Traceback (most recent call last): >> File "<interactive input>", line 1, in <module> >> OperationalError: no such function: group_concat >> >> is there model that should be installed but i am missed? > > Most likely an out-of-date SQLite library. > >> by the way, i often see other guys has sqlite command mode, just like >> sqlplus, >> sqlite> >> >> but i have not seen it in my pc, could some one helps me on this tool? > > That's the "sqlite3" command line tool. > > -j > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Our opponent is an alien starship packed with atomic bombs. We have > a protractor." "I'll go home and see if I can scrounge up a ruler > and a piece of string." --from Anathem by Neal Stephenson > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
