Re: [sqlite] Testing Sqlite3* DB_handle?

2017-01-02 Thread Keith Medcalf
On Monday, 2 January, 2017 19:29, Domonic Tom wrote: > Is there a way to test whether the DB_handle used when opening a database > is good? Can you define "good", and provide an example that would meet the converse, "ungood"? Clearly a NULL (0) pointer is "ungood" (as is

Re: [sqlite] Testing Sqlite3* DB_handle?

2017-01-02 Thread Simon Slavin
On 3 Jan 2017, at 2:28am, Domonic Tom wrote: > Is there a way to test whether the DB_handle used when opening a database is > good? > > I need to find some way of testing it to make sure it represents the live > connection to a database? It’s a little complicated. You

[sqlite] Testing Sqlite3* DB_handle?

2017-01-02 Thread Domonic Tom
Is there a way to test whether the DB_handle used when opening a database is good? I need to find some way of testing it to make sure it represents the live connection to a database? Is that possible? Thanks ___ sqlite-users mailing list

Re: [sqlite] problem with sqlite 4

2017-01-02 Thread David Empson
> On 3/01/2017, at 4:48 AM, claude.del-vi...@laposte.net wrote: > > Hi, > > The problem described here occurs both with the x32 and x64 versions of the > expert personal 4 (Windows 10). Hereafter, a little database to show the bug. > > The table "sample" is used to store words occurring in

[sqlite] problem with sqlite 4

2017-01-02 Thread claude . del-vigna
Hi, The problem described here occurs both with the x32 and x64 versions of the expert personal 4 (Windows 10). Hereafter, a little database to show the bug. The table "sample" is used to store words occurring in texts. Texts are identified by an id number. CREATE TABLE IF NOT EXISTS

[sqlite] can not use row values from inside a trigger

2017-01-02 Thread E.Pasma
I'm using SQLite only for private purpose. This also allows me to try incredably complex queries. And find that SQLite is reliable indeed and fast. Currently I try to execute a script of 30 statements from inside a trigger. And amazed to not have any error. Except one, when using the new

[sqlite] What is the best way to select "evenly" ?

2017-01-02 Thread Ron Aaron
Hello, all - I'm trying to select from a table which contains pairs of "id", "name", where the "name" may appear in multiple "ids". For example, the table might have "10", "abc" "20", "abc" "10", "def" "10", "ghi" "20", "ghi" etc.That is, not every id will have every name in it. What I