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?
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?

thanks.
Daisy
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to