Re: [sqlite] Odd question

Simon Slavin wrote on Saturday, December 16, 2017 5:15 PM >>On 16 Dec 2017, at 9:43pm, Nelson, Erik - 2 >>wrote: >> I'm using an application that I can't change. I can give it multiple >> queries to run but the application assumes that each query will produce

Re: [sqlite] EXTERNAL: Re: Possibly uninitialized variables...compile time error

Thank you. I'm looking forward to a clean build on the next release. ___ Mark C Edwards Chief Scientist, C2 Systems Engineering & Integration 779 Monika Ct Chubbuck, ID 83202 mark.c.edwa...@leidos.com Mobile: 208-241-7982 -Original Message- From:

Re: [sqlite] Odd question

Petern wrote on Saturday, December 16, 2017 4:53 PM Re: Nelson "odd". This will make the desired (?) side effect happen: >.load eval.so >SELECT coalesce(eval('INSERT INTO table1 VALUES(a, b, c)'), 1) AS value; >If INSERT references columns from an outer scope then use printf() inside the

Re: [sqlite] Odd question

On 16 Dec 2017, at 9:43pm, Nelson, Erik - 2 wrote: > I'm using an application that I can't change. I can give it multiple queries > to run but the application assumes that each query will produce at least one > row and causes an error if that's not the

Re: [sqlite] Odd question

Re: Nelson "odd". This will make the desired (?) side effect happen: .load eval.so SELECT coalesce(eval('INSERT INTO table1 VALUES(a, b, c)'), 1) AS value; If INSERT references columns from an outer scope then use printf() inside the eval(). From a program, use

Re: [sqlite] Odd question

Keith Medcalf wrote on Sent: Saturday, December 16, 2017 4:04 PM >Your method of achieving a solution to whatever problem you are trying to >solve will not work. >Perhaps you can state the problem you are trying to solve without making an >assumption as to how to solve that problem, someone

[sqlite] Odd question

Nelson, Erik - 2 ​, on​ Sat, 16 Dec 2017 11:54:06 ​, wrote:​ ​> ​ For unfortunate reasons, I need a query that does an insert and also returns at ​> ​ least one row... for example, something along the lines of ​>​ ​> ​ Select 1 as value from (insert into table1 values(a, b, c)) ​>​ ​> Or ​> ​> ​

Re: [sqlite] Odd question

On 2017/12/16 9:53 PM, Nelson, Erik - 2 wrote: For unfortunate reasons, I need a query that does an insert and also returns at least one row... for example, something along the lines of Select 1 as value from (insert into table1 values(a, b, c)) Or Select coalesce((insert into table1

Re: [sqlite] Odd question

Your method of achieving a solution to whatever problem you are trying to solve will not work. Perhaps you can state the problem you are trying to solve without making an assumption as to how to solve that problem, someone may be able to solve the problem with a workable solution rather than

[sqlite] Odd question

For unfortunate reasons, I need a query that does an insert and also returns at least one row... for example, something along the lines of Select 1 as value from (insert into table1 values(a, b, c)) Or Select coalesce((insert into table1 values(a, b, c)), 1) as value I've tried a number of

Re: [sqlite] DateTime kind stored as undefined

Hello, > my connection string looks like this: > *var connection = new SQLiteConnection("DateTimeKind=Utc;Data > Source=:memory:");* > Here is a blog post about it (settig datetimekind in utc for sqlite) on > which I based: >

Re: [sqlite] Missing data table

At 14:51 16/12/2017, you wrote: Just joined the list. Am a fairly long term user of SQLite Expert Personal (my version is 3.5.96.2516 - I upgraded to try version 4 a while back but the columns in the Data tab were fixed which is no good for me, I couldn't drag them wider so I went back to

Re: [sqlite] Missing data table

On 16 Dec 2017, at 1:51pm, Chris B wrote: > Twice now in the last two months, the "Aircraft" table has vanished from my > dad's database effectively showing no data in the data tab on the main > window, but the file size has remained the same, suggesting the data is

[sqlite] Missing data table

Afternoon all, Just joined the list. Am a fairly long term user of SQLite Expert Personal (my version is 3.5.96.2516 - I upgraded to try version 4 a while back but the columns in the Data tab were fixed which is no good for me, I couldn't drag them wider so I went back to v3), and while I

Re: [sqlite] SQLite3 on WinCE platform

>From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On >Behalf Of Simon Slavin >Sent: Monday, December 11, 2017 12:50 PM >To: SQLite mailing list >Subject: Re: [sqlite] SQLite3 on WinCE platform > >On 11 Dec 2017, at 8:59am, Ertan

Re: [sqlite] What happens if an in memory database runs out of memory

I’m with you Simon but the program I’m working on will probably only ever be used by me. I just like to try and do things properly as a means of learning. I’m using win64 with 16GB RAM and 512GB SSD so everything’s already fast. I only tested in win32 so I’d run out of memory a lot quicker.