Re: [sqlite] User Functions

There's no good way to handle graphs in SQL. If you had a tree, you could use Celko's nested-set scheme, but from your description, you don't have a tree (unless you're looking at it upside-down). Celko's book, _SQL for Smarties_, has a short chapter on handling non-tree graphs. Also there's a

Re: [sqlite] ATTACH causes SQLITE_ERROR with reason of "database is locked"

[EMAIL PROTECTED] wrote: I'm occasionally seeing ATTACH failing. sqlite_get_table_vprintf() is returning SQLITE_ERROR (not SQLITE_LOCKED!) but the error string is set to "database is locked". (The query is "ATTACH '/dbpath/global.db' AS global;") The primary database (the open one to which I'm

[sqlite] ATTACH causes SQLITE_ERROR with reason of "database is locked"

I'm occasionally seeing ATTACH failing. sqlite_get_table_vprintf() is returning SQLITE_ERROR (not SQLITE_LOCKED!) but the error string is set to "database is locked". (The query is "ATTACH '/dbpath/global.db' AS global;") The primary database (the open one to which I'm attempting to attach the

[sqlite] Multiple-column subqueries

I'd like to be able to check whether composite keys in one table exist in another. The following syntax is supported by Oracle: SELECT * FROM TABLE_1 WHERE ( TABLE_1.KEY_1, TABLE_1.KEY_2 ) IN ( SELECT KEY_1, KEY_2 FROM TABLE_2 ); When I try it in SQLite, I get the

[sqlite] Pragma setting

HI, there are some PRAGMAs in SQLite sql language, is there way hoe to get info about how are they set? Brona - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]