I am trying to use TEMP TRIGGER inside my code but every time I use it I
receive a "SQL logic error or missing database" error.
I compiled sqlite with the option SQLITE_OMIT_TEMPDB.
but analyzing the source code I can see for example:
#ifndef SQLITE_OMIT_TRIGGER
/* If there are TEMP triggers on this table, modify the sqlite_temp_master
** table. Don't do this if the table being ALTERed is itself located in
** the temp database.
*/
if( (zWhere=whereTempTriggers(pParse, pTab))!=0 ){
sqlite3NestedParse(pParse,
"UPDATE sqlite_temp_master SET "
"sql = sqlite_rename_trigger(sql, %Q), "
"tbl_name = %Q "
"WHERE %s;", zName, zName, zWhere);
sqlite3DbFree(db, zWhere);
}
#endif
so sqlite_temp_master is necessary in order to use TEMP TRIGGER and so I can
use TEMP TRIGGER only if I recompile sqlite without the SQLITE_OMIT_TEMPDB
macro.
Anyone can confirm my assumption?
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
