[sqlite] Drop Trigger with Select
Hi, Is there any way that I could drop a trigger by providing the results of a query? Something similar to the following?: DROP TRIGGER (SELECT name from trigger_status where status = 1); Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Make Test Failure Without tcl.h
I'm having trouble running make test when I don't have tcl-devel rpm installed (which contains tcl.h). I've tried both with and without --disable-tcl but it seems like the tests don't care that I've disabled tcl. I can't easily change my build machines (ie installing tcl-devel) so I'm wondering how I might get this working. ... .c ../../../src/ext/fts3/fts3_hash.h ../../../src/ext/fts3/fts3_icu.c ../../../src/ext/fts3/fts3_porter.c ../../../src/ext/fts3/fts3_tokenizer.h ../../../src/ext/fts3/fts3_tokenizer.c ../../../src/ext/fts3/fts3_tokenizer1.c ../../../src/ext/icu/sqliteicu.h ../../../src/ext/icu/icu.c ../../../src/ext/rtree/rtree.h ../../../src/ext/rtree/rtree.c tsrc rm tsrc/sqlite.h.in tsrc/parse.y touch .target_source tclsh8.4 ../../../src/tool/mksqlite3c.tcl ./libtool --mode=link gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I../../../src/src -D_HAVE_SQLITE_CONFIG_H -DNDEBUG -DSQLITE_THREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_OMIT_LOAD_EXTENSION=1 -DTCLSH=1 -DSQLITE_TEST=1 -DSQLITE_NO_SYNC=1\ -DSQLITE_CRASH_TEST=1 \ -DSQLITE_SERVER=1 -DSQLITE_PRIVATE= -DSQLITE_CORE -DSQLITE_TEMP_STORE=1 \ -o testfixture ../../../src/src/test1.c ../../../src/src/test2.c ../../../src/src/test3.c ../../../src/src/test4.c ../../../src/src/test5.c ../../../src/src/test6.c ../../../src/src/test7.c ../../../src/src/test8.c ../../../src/src/test9.c ../../../src/src/test_autoext.c ../../../src/src/test_async.c ../../../src/src/test_btree.c ../../../src/src/test_config.c ../../../src/src/test_devsym.c ../../../src/src/test_func.c ../../../src/src/test_hexio.c ../../../src/src/test_malloc.c ../../../src/src/test_md5.c ../../../src/src/test_mutex.c ../../../src/src/test_onefile.c ../../../src/src/test_osinst.c ../../../src/src/test_schema.c ../../../src/src/test_server.c ../../../src/src/test_tclvar.c ../../../src/src/test_thread.c ../../../src/src/tclsqlite.c sqlite3.c -lpthread libtool: link: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I../../../src/src -D_HAVE_SQLITE_CONFIG_H -DNDEBUG -DSQLITE_THREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_OMIT_LOAD_EXTENSION=1 -DTCLSH=1 -DSQLITE_TEST=1 -DSQLITE_NO_SYNC=1 -DSQLITE_CRASH_TEST=1 -DSQLITE_SERVER=1 -DSQLITE_PRIVATE= -DSQLITE_CORE -DSQLITE_TEMP_STORE=1 -o testfixture ../../../src/src/test1.c ../../../src/src/test2.c ../../../src/src/test3.c ../../../src/src/test4.c ../../../src/src/test5.c ../../../src/src/test6.c ../../../src/src/test7.c ../../../src/src/test8.c ../../../src/src/test9.c ../../../src/src/test_autoext.c ../../../src/src/test_async.c ../../../src/src/test_btree.c ../../../src/src/test_config.c ../../../src/src/test_devsym.c ../../../src/src/test_func.c ../../../src/src/test_hexio.c ../../../src/src/test_malloc.c ../../../src/src/test_md5.c ../../../src/src/test_mutex.c ../../../src/src/test_onefile.c ../../../src/src/test_osinst.c ../../../src/src/test_schema.c ../../../src/src/test_server.c ../../../src/src/test_tclvar.c ../../../src/src/test_thread.c ../../../src/src/tclsqlite.c sqlite3.c -lpthread In file included from ../../../src/src/test1.c:18: ../../../src/src/sqliteInt.h:225:18: tcl.h: No such file or directory ../../../src/src/test1.c:77: error: syntax error before Tcl_Interp ../../../src/src/test1.c: In function `get_sqlite_pointer': ../../../src/src/test1.c:82: error: `Tcl_CmdInfo' undeclared (first use in this function) ../../../src/src/test1.c:82: error: (Each undeclared identifier is reported only once ../../../src/src/test1.c:82: error: for each function it appears in.) ../../../src/src/test1.c:82: error: syntax error before cmdInfo ... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
