On 26 June 2012 14:21, Igor Tandetnik <[email protected]> wrote: > Vivien Malerba <[email protected]> wrote: > > Is there any possibility to be notified when a table is created (when a > > "CREATE TABLE XXX" is executed)? > > How is it executed? Isn't it your program that executes the statement? How > come you don't know when that happens? >
The code is some SQL entered by the user, I have no control over it. There is effectively the possibility to parse the SQL entered, detect the CREATE table statement and act accordingly, but I would like to see if SQLite has some kind of builtin feature I could use first. Also, for example if the user executes a query as "CREATE TABLE xxx AS SELECT ..." then it's much more difficult to know how to define the XXX table as I would have to parse the SELECT query part as well. It's doable of course but can become a bit complicated. Regards, Vivien _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
