Re: [sqlite] Extension Loading

Green Fields wrote: > conn.EnableExtensions(true); > conn.LoadExtension("mod_spatialite"); > > works fine, but I need to use the SQL function > > conn.EnableExtensions(true); > cmd.CommandText = @"SELECT load_extension('mod_spatialite');"); > int i = cmd.ExecuteNonQuery(); > > raises > >

[sqlite] Extension Loading

Hi I'm using System.Data.SQLite Nuget package and attempting to load an extension. All depenent libraries are in the bin\debug output directory. Extension is 32 bit and the project is set to compile for 32 bit Using conn.EnableExtensions(true);(I think this is enabled by default)

Re: [sqlite] Inserts silently failing

On Sunday, 12 February, 2017 07:28, Brian Macy said: > Recently I removed a bunch of latency from my application. Suddenly I’m > getting odd errors where a record that was just inserted can’t be read by > the same process. SQLite does not do "per process"

Re: [sqlite] Inserts silently failing

On 12 Feb 2017, at 2:27pm, Brian Macy wrote: > Recently I removed a bunch of latency from my application. Suddenly I’m > getting odd errors where a record that was just inserted can’t be read by the > same process. In fact, even waiting till completion of the run, the

[sqlite] Inserts silently failing

I have an application where multiple engines perform heavy write OLTP transactions on a repository. The engine supports many data stores and I recently added SQLite support. WAL is great, for small single node stuff SQLite is very fast and simple. I had turned of synchronous (=0), as for the

Re: [sqlite] pragma_table_info column name is interpreted as reserved work?

On Sun, 12 Feb 2017 12:40:27 -0700 "Keith Medcalf" wrote: > I am aware that it works if you quote the apparently reserved word > "notnull". That's the queer part. I can imagine "not" and "null" as keywords, but not "nonnull". --jkl

[sqlite] Minor bugs in documentation

Hi, I found the following bugs in the online documentation: - In http://sqlite.org/testing.html#test_harnesses, the link to "fuzz tests" has an incorrect href attribute, '#fuzztests' instead of #fuzztests (superfluous quotes, causes the link to go to the wrong place (404)). - In

Re: [sqlite] pragma_table_info column name is interpreted as reserved work?

On Sunday, 12 February, 2017 11:03, Domingo Alvarez Duarte wrote: > Hello Keith ! > You can try this that works: > select m.name as TableName, > i.cidas ColumnID, > i.name as ColumnName, > i.type as Affinity, >

Re: [sqlite] pragma_table_info column name is interpreted as reserved work?

Hello Keith ! You can try this that works: select m.name as TableName, i.cidas ColumnID, i.name as ColumnName, i.type as Affinity, i."notnull"as CanBeNull, i.dflt_value as DefaultValue, i.pk as PrimaryKeySeq from

[sqlite] pragma_table_info column name is interpreted as reserved work?

select m.name as TableName, i.cidas ColumnID, i.name as ColumnName, i.type as Affinity, i.notnullas CanBeNull, i.dflt_value as DefaultValue, i.pk as PrimaryKeySeq from sqlite_master as m,

[sqlite] INDEX list

Thanks very much Niall, the SELECT DISTINCT column FROM table is doing exactly what I was looking for. The ORDER BY clause gives the whole list and that's not what I wanted. Regards, Rob -- This email and any attachments to it may be confidential and are intended solely for the use of the

Re: [sqlite] Pragma table-valued functions used in views in an attached database.

On 12 Feb 2017, at 11:10am, Constantine Yannakopoulos wrote: > On Sun, Feb 12, 2017 at 12:53 PM, Simon Slavin wrote: >> You might have missed >> >> >> >> which, despite its name, also works

Re: [sqlite] Pragma table-valued functions used in views in an attached database.

On Sun, Feb 12, 2017 at 12:53 PM, Simon Slavin wrote: > You might have missed > > > > which, despite its name, also works with views. No, this returns the columns of a single table. Suggested pragma table_list/view_list

Re: [sqlite] Pragma table-valued functions used in views in an attached database.

On 12 Feb 2017, at 10:39am, Constantine Yannakopoulos wrote: > perhaps the addition of two more pragmas: > > pragma table_list(database-name); > pragma view_list(database-name); > > would help. You might have missed

[sqlite] Pragma table-valued functions used in views in an attached database.

Hi, Trying to create an attached information schema using the instructions in the additional notes of the "Pragma functions" section of https://www.sqlite.org/pragma.html I have come across an issue. I execute the following statements in any sqlite database: attach :memory: as info; drop view