Re: [sqlite] sqlite shell: arrow keys

Depends on your system I think. Here is what is contained in shell.c readline.h is the thing making all those history and similar things you use in your linux command line shell available. #ifdef HAVE_EDITLINE # include #endif #if defined(HAVE_READLINE) && HAVE_READLINE==1 # include # include

[sqlite] sqlite shell: arrow keys

Dear SQLiters, I am new to SQLite and learning it (and SQL) using shell. It would make life easier if arrow keys on keyboard could be used to scroll through command history and along command for editing. Is there a way to enable this? Thank you, Roman

Re: [sqlite] System.Data.SQLite: Failing APTCA Check

DevTeam wrote: > > Next I downloaded and ran the binscope.exe utility against just the > System.Data.Sqlite.dll file to isolate the test to just this file and > received the same result - Failed checks - the assembly has > AllowPartiallyTrustedCallersAttribute (APTCA). > The use of this

Re: [sqlite] (no subject)

That worked thanks Igor. On 16 May 2013 15:33, Paul Sanderson wrote: > Rob yes thats correct > > Igor - thanks I'll give that a go > > > > On 16 May 2013 14:51, Rob Richardson wrote: > >> First idea: include a subject line. >> >> I'm not

[sqlite] System.Data.SQLite: Failing APTCA Check

Hi all, Was wondering if anyone can give me some insight or advice on the how to proceed with the following situation: I'm writing a 32 bit Windows 8 desktop application in C#, .net framework 4.5, using System.Data.Sqlite version 1.0.85. I'm using the Nuget package System.Data.Sqlite.x86

Re: [sqlite] (no subject)

Rob yes thats correct Igor - thanks I'll give that a go On 16 May 2013 14:51, Rob Richardson wrote: > First idea: include a subject line. > > I'm not 100% clear on your message. You said: > " For those entries in table1 where there is a null in t2..." > I'm

Re: [sqlite] (no subject)

First idea: include a subject line. I'm not 100% clear on your message. You said: " For those entries in table1 where there is a null in t2..." I'm guessing you wanted to say: " For those entries in table1 where there is a null in t1..." Is that right? RobR

Re: [sqlite] (no subject)

On 5/16/2013 9:29 AM, Paul Sanderson wrote: I have two tables of the form create table1 (id1 int, t1 text) create table2 (id2 int unique, t2 text) For those entries in table1 where there is a null in t2 I want to copy the corresponding entry from table2 update table1 set t1=(select t2 from

[sqlite] (no subject)

I have two tables of the form create table1 (id1 int, t1 text) create table2 (id2 int unique, t2 text) the data in table 1 is such that some values for t1 are NULL ID1 can contain duplicates ID2 is unique and for every instance of ID1 in table1 there will be a corresponding ID2 entry in table2

Re: [sqlite] Missing optimization with id BETWEEN xxx AND xxx?

If you replace "between x and x" (which is just a very inefficient method of testing for equality) with "= x" the query reverts to the same plan as "IN (x,...)" with the small difference that the constant values are assigned to registers first. -Ursprüngliche Nachricht- Von: Dominique