>De: [EMAIL PROTECTED] >Fecha: 27/05/2008 19:56 > >It's not supposed to, according to >http://sqlite.org/lang_createtrigger.html . The syntax >only allows select, insert, update and delete statements. > >What are you trying to achieve?
I need to handle tables with several million records, on realtime, from RAM. One of the fields takes few values (say, company website id), but new ids are added from time to time. I would prefer to dynamically create a set of tables when a new id shows up, for the improved locality of reference plus reduced overhead from the website id and its non-unique index. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users