On 7 Jan 2010, at 8:29am, Fabio Spadaro wrote: > I'm building an wxPython' application in advanced cases may require a > user to write a query and run it. I would also expect that the same > query is saved in the database to be reused whenever you want. > Someone gives me an indication?
Sure. Use sqlite3_exec() to execute the query (since it will be supplied as a long string of text rather than bound variables). And use a table with a TEXT column to store the queries in. http://www.sqlite.org/c3ref/exec.html You may have to deal with attempts to hack your database (i.e. to execute some command other than a SELECT), and you'll have to deal with quote signs carefully when you store and retrieve your queries. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
