Re: [sqlite] sqlite3_get_table question

Hi, thanks Dan. This was certainly the problem, since there are a lot of zeros in the data. In the meahnwhile I tried out something different. I heard from the incremental blob API. And it worked!!! Here is how I solved it: if(sqlite3_prepare_v2(db, cmd, strlen(cmd), , 0) != SQLITE_OK) {

[sqlite] memory usage

Hello, My multi-threaded application has various sqlite db's open simultaneously, in memory using the :memory: keyword, disk based db's and at times, tmpfs (ram) db's. Is there a way to view each individual database's memory usage? I found the functions sqlite3_memory_used() and

[sqlite] memory usage

Hello, My multi-threaded application has various sqlite db's open simultaneously, in memory using the :memory: keyword, disk based db's and at times, tmpfs (ram) db's. Is there a way to view each individual database's memory usage? I found the functions sqlite3_memory_used() and

Re: [sqlite] Drop Trigger with Select

Hi, My idea would be a to define a function which drops the trigger and returns some dummy value and call ist like this: SELECT MyDropFunction(name) from trigger_status where status = 1 However, i do not know if this will work. Martin timdbu...@gmail.com schrieb: > Hi, > Is there any way

[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

[sqlite] SQLite 3.6.7 does not create dynamic library with .dylib suffix when compiled under MacOSX 10.3.9

Hello, I compiled the latest amalgamation under MacOSX 10.3.9 and while the compilation completed successfully, the dynamic library created does not have a file ending of ".dylib". I would have expected the library created to be named "libsqlite3.0.8.6.dylib" but it was named just