Mark Sent: Tuesday, December 19, 2017 1:32 AM
On Mon Dec 18, 2017 at 04:48:27PM +, Nelson, Erik - 2 wrote:
> Nomad Sent: Sunday, December 17, 2017 4:11 PM
> >On Sat Dec 16, 2017 at 07:53:22PM +, Nelson, Erik - 2 wrote:
>
> >> Select 1 as value from (insert into table1 values(a, b, c)) I'
On Mon Dec 18, 2017 at 04:48:27PM +, Nelson, Erik - 2 wrote:
> Nomad Sent: Sunday, December 17, 2017 4:11 PM
> >On Sat Dec 16, 2017 at 07:53:22PM +, Nelson, Erik - 2 wrote:
>
> >> Select 1 as value from (insert into table1 values(a, b, c)) I've
> >> tried a number of options but haven't b
Keith Medcalf Sent: Monday, December 18, 2017 2:31 PM
...snipped a lot...
>>Right, all of the statements are step'd regardless of the result of
>>sqlite3_column_count(). SQLITE_DONE is returned from the first
>>step() for insert queries.
>>In pseudocode, it's
>>prepare("insert...") //okay
>>
On Monday, 18 December, 2017 11:35
>Keith Medcalf Sent: Monday, December 18, 2017 1:07 PM
>To: SQLite mailing list
>Subject: Re: [sqlite] Odd question
>>>I investigated a further while exploring some of the list
>>>suggestions. The app halts with an error unless
&g
Keith Medcalf Sent: Monday, December 18, 2017 1:07 PM
To: SQLite mailing list
Subject: Re: [sqlite] Odd question
>>I investigated a further while exploring some of the list
>>suggestions. The app halts with an error unless
>>sqlite3_column_count() > 0. That means I miss
Kees Nuyt Sent: Monday, December 18, 2017 12:51 PM
On Sat, 16 Dec 2017 21:43:44 +, "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
>I investigated a further while exploring some of the list
>suggestions. The app halts with an error unless
>sqlite3_column_count() > 0. That means I misspoke when I mentioned
>that the sql statement needed to return at least one row. I’m not
>sure if that makes a difference, though.
That makes
Keith Medcalf Sent: Sunday, December 17, 2017 4:30 PM
>How do you know the insert is not working? Have you verified that the data is
>not being inserted or are you simply relying on a popup provided by the
>application? If the later, you should be aware that the application can
>pop-up whatev
On Sat, 16 Dec 2017 21:43:44 +, "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. I want to cause some
Peter Da Silva Sent: Monday, December 18, 2017 12:24 PM
>What I don’t understand is this app that’s making SQLite calls, so it’s using
>the SQLite library, and it’s expecting a result from updates and inserts?
Yes, exactly. The app designers assumed that rows are returned from every
statement
What I don’t understand is this app that’s making SQLite calls, so it’s using
the SQLite library, and it’s expecting a result from updates and inserts?
That seems like a bug or design flaw in the application.
Possibly it’s looking for the number of rows effected result and not finding it
for so
Nomad Sent: Sunday, December 17, 2017 4:11 PM
>On Sat Dec 16, 2017 at 07:53:22PM +, 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 t
Nelson, Erik - 2 Sent: Saturday, December 16, 2017 5:27 PM
>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
ginal Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Nelson, Erik - 2
>Sent: Saturday, 16 December, 2017 14:44
>To: SQLite mailing list
>Subject: Re: [sqlite] Odd question
>
>Keith Medcalf wrote on Sent: Saturday, December 16, 2017
On Sat Dec 16, 2017 at 07:53:22PM +, 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 coales
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
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
ted traffic volume.
>
> >-Original Message-
> >From: sqlite-users [mailto:sqlite-users-
> >boun...@mailinglists.sqlite.org] On Behalf Of Nelson, Erik - 2
> >Sent: Saturday, 16 December, 2017 12:53
> >To: SQLite mailing list
> >Subject: [sqlite] Odd questio
n...@mailinglists.sqlite.org] On Behalf Of Nelson, Erik - 2
>Sent: Saturday, 16 December, 2017 12:53
>To: SQLite mailing list
>Subject: [sqlite] Odd question
>
>For unfortunate reasons, I need a query that does an insert and also
>returns at least one row... for example, somethi
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(
ent: Saturday, 16 December, 2017 12:53
>To: SQLite mailing list
>Subject: [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 t
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
24 matches
Mail list logo