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 at
>> least one row and causes an
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:
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
>eval()
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 case.
Will the application recognise
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 https://sqlite.org/c3ref/load_exten
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 may
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
>
>
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 values(
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 a
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 opt
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:
>
https://www.thomaslevesque.com/2015/06/28/how-to-retrieve-dates-as-utc
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 v3),
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 in
> there somewhere but
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 bui
>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 Küçükoğlu wrote:
>
>> Error I am getting wh
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.
_
16 matches
Mail list logo