[sqlite] SQLite.NET.chm pages are empty

Hi, I downloaded the SQLite.NET.chmfrom the trunk [1]in order to access the .NET documentation but the pages are empty. Regards, Mathieu Schroeter [1]: http://system.data.sqlite.org/index.html/doc/trunk/Doc/SQLite.NET.chm?mimetype=application/x-chm

Re: [sqlite] SQLite.NET.chm pages are empty

Mathieu Schroeter wrote: > > I downloaded the SQLite.NET.chm from the trunk in order to access the .NET > documentation but the pages are empty. > Actually, this is the result of a Windows security feature that disables downloaded content. To enable it, navigate to the file in Windows

Re: [sqlite] SQLite.NET.chm pages are empty

Le 29.04.2013 11:35, Joe Mistachkin a écrit : Mathieu Schroeter wrote: I downloaded the SQLite.NET.chm from the trunk in order to access the .NET documentation but the pages are empty. Actually, this is the result of a Windows security feature that disables downloaded content. To enable it,

Re: [sqlite] Bug in resolving aliases with parentheses in join

Ah, I overlooked that and just assumed it was correct since sqlite accepted it. Thanks for your help! The reason we need this is that we're procedurally generating SQL queries, and it's easier to insert parentheses everywhere than just in the (very) few join clauses where they are actually

[sqlite] sqlite_interrupt() does not cancel ATTACHing of blocked database

Hi, seems like sqlite_interrupt() does not cancel ATTACHing of blocked database.  Steps to reproduce problem:  1. open 'foo.db' in shell,  run 'BEGIN EXCLUSIVE';  2. switch to custom application and open ":memory:" database in it; set busy timeout to 15 seconds and run "ATTACH 'foo.db' as db"

[sqlite] How to write this code?

Hi, ALL, I need to make a loop and in the loop I need to do following: void CDb::Bar() { int result; if( ( result = sqlite3_prepare_v2( m_handle, query1, -1, , 0 ) == SQLITE_OK ) sqlite3_step( stmt ); else { // error message sqlite3_exec( m_handle,

Re: [sqlite] How to write this code?

On 29 Apr 2013, at 7:55pm, Igor Korot wrote: > Problem is sqlite3_prepare_v2() wastes time by compiling SQL statements and > I'd like to avoid it by making this call only once and just > bind the appropriate parameters on each loop iteration. > > Would it be possible if I

Re: [sqlite] How to write this code?

Simon, On Mon, Apr 29, 2013 at 12:18 PM, Simon Slavin wrote: > > On 29 Apr 2013, at 7:55pm, Igor Korot wrote: > > > Problem is sqlite3_prepare_v2() wastes time by compiling SQL statements > and > > I'd like to avoid it by making this call only once and

[sqlite] How do I write this query

Hi, ALL, CREATE TABLE foo( a integer, b integer); INSERT INTO foo VALUES( 1,1); INSERT INTO foo VALUES( 1,2); INSERT INTO foo VALUES( 1,3); INSERT INTO foo VALUES( 2,1); INSERT INTO foo VALUES( 2,2); INSERT INTO foo VALUES( 2,3); CREATE TABLE bar( a integer, b integer, c integer); INSERT INTO

Re: [sqlite] How do I write this query

Why are basic SQL questions being asked in the SQLite forum? On Mon, Apr 29, 2013 at 5:06 PM, Igor Korot wrote: > Hi, ALL, > > CREATE TABLE foo( a integer, b integer); > INSERT INTO foo VALUES( 1,1); > INSERT INTO foo VALUES( 1,2); > INSERT INTO foo VALUES( 1,3); > INSERT

Re: [sqlite] How to write this code?

On 29 Apr 2013, at 8:56pm, Igor Korot wrote: > Yes, I read this link. But I don't understand how it applies here. > Can you make some pseudo code, please? I'm sorry, but if you're using a class someone else wrote you may not be able to use sqlite3_reset(). It depends on

Re: [sqlite] How do I write this query

sqlite> CREATE TABLE foo( a integer, b integer); sqlite> INSERT INTO foo VALUES(1,1); sqlite> INSERT INTO foo VALUES(1,2); sqlite> INSERT INTO foo VALUES(1,3); sqlite> INSERT INTO foo VALUES(2,1); sqlite> INSERT INTO foo VALUES(2,2); sqlite> INSERT INTO foo VALUES(2,3); sqlite> CREATE TABLE bar( a

Re: [sqlite] How do I write this query

Thx. On Mon, Apr 29, 2013 at 2:14 PM, Michael Black wrote: > sqlite> CREATE TABLE foo( a integer, b integer); > sqlite> INSERT INTO foo VALUES(1,1); > sqlite> INSERT INTO foo VALUES(1,2); > sqlite> INSERT INTO foo VALUES(1,3); > sqlite> INSERT INTO foo VALUES(2,1); >

Re: [sqlite] How to write this code?

Simon, On Mon, Apr 29, 2013 at 2:10 PM, Simon Slavin wrote: > > On 29 Apr 2013, at 8:56pm, Igor Korot wrote: > > > Yes, I read this link. But I don't understand how it applies here. > > Can you make some pseudo code, please? > > I'm sorry, but if

Re: [sqlite] How do I write this query

On Mon, 29 Apr 2013 16:14:00 -0500 "Michael Black" wrote: > sqlite> CREATE TABLE foo( a integer, b integer); > sqlite> INSERT INTO foo VALUES(1,1); > sqlite> INSERT INTO foo VALUES(1,2); > sqlite> INSERT INTO foo VALUES(1,3); With 3.7.13 at least, insert into foo