BareFeet wrote: > >> Since you can't use a create table statement in a trigger, > > Yes, I thought of doing that and realized the limitation of triggers > not allowing create temporary table. Is this restriction part of > standard SQL, or just SQLite? Is it likely to change? It seems a > common need. >
Tom, Standard SQL doesn't allow any SQL-Schema statements (basically any create or drop statements) in a trigger body. I doubt this will ever change. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users