Re: [sqlite] ensuring uniqueness of tuples spanning across multipletables?

> Jim Morris writes: > The recent thread may relate: "[sqlite] Is there an efficient way to > insert unique rows (UNIQUE(a, b, c)) into an fts3 virtual table?" > INSERT INTO fts3_table (a,b,c) > SELECT 'an A','a B','a C' > WHERE NOT EXISTS > (SELECT DISTINCT a,b,c > FROM fts3_table >

[sqlite] System.Data.SQLite Exception with wrong password

Hi, I'm using a password protected database. When I type the wrong password in my app the resulting Exception is a SQLiteException with this message: "File opened is not a database file". The ErrorCode is set to "NotADatabase". Wouldn't it more correct if this code is set to something like

Re: [sqlite] DateTimeOffset in SQLite

Steffen Mangold wrote: > how to use DateTimeOffset with Sqlite, if it is possible? What's DateTimeOffset? Offset from what to what? What exactly are you trying to achieve? See if this helps: http://www.sqlite.org/lang_datefunc.html -- Igor Tandetnik

[sqlite] DateTimeOffset in SQLite

Hi all, how to use DateTimeOffset with Sqlite, if it is possible? Regards Steffen Mangold ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Meaning of sqlite3_wal_checkpoint_v2 parameters

Hi! Can you help me understand more exactly what the output parameters are from sqlite3_wal_checkpoint_v2()? Specifically: 1) What is the relationship between pnLog and pnCkpt: is pnLog>=pnCkpt always true? 2) Under what circumstances would pnLog>pnCkpt be true? Also, can you confirm I

[sqlite] Sqlite WPF application (designer view) toolbox greyed out

I successfully built a .NET Forms application in VS2010 using the toolbox to add a SqlLiteConnection etc. by dragging the connection symbol from the toolbox into designer view of the corresponding source file. This gave me all required class variables and what was needed to program the