Re: [sqlite] Query on Update or Selective Insert

2013-08-07 Thread Simon Davies
On 7 August 2013 15:25, Simon Slavin  wrote:
>
> On 7 Aug 2013, at 9:50am, techi eth  wrote:
>
>> I am trying to update 100 variables at a time & due to some of the reason 99
>> th or any mid index variable cause update to fail.
>>
>> In that case this query has to execute it again for the entire variable or
>> only for failed variable.
>
> If the whole of the UPDATE cannot be completed, none of the UPDATE is done.
>
> Simon.

If a conflict arises, none of the row is updated.
But see http://www.sqlite.org/lang_conflict.html. An update with
ignore conflict resolution can update rows even if some rows cause
conflict; those rows that cause conflict will be skipped.

Regards,
Simon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Query on Update or Selective Insert

2013-08-07 Thread Simon Slavin

On 7 Aug 2013, at 9:50am, techi eth  wrote:

> I am trying to update 100 variables at a time & due to some of the reason 99
> th or any mid index variable cause update to fail.
> 
> In that case this query has to execute it again for the entire variable or
> only for failed variable.

If the whole of the UPDATE cannot be completed, none of the UPDATE is done.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Query on Update or Selective Insert

2013-08-07 Thread Hick Gunter
The standard behavior is to back out any changes made by the current statement, 
which means that none of the changes to any of the rows are preserved in case 
of a constraint violation.

SQLite offers an ON CONFLICT clause which allows the programmer to choose from 
a set of defined behaviours. See http://www.sqlite.org/lang_conflict.html

But regardless of the choice, each row of a table is either modified in all 
specified columns or in none at all.

Note that without a WHERE clause the UPDATE statement will modify all rows of 
the table.

-Ursprüngliche Nachricht-
Von: techi eth [mailto:techi...@gmail.com]
Gesendet: Mittwoch, 07. August 2013 12:06
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Query on Update or Selective Insert

Apologies to use programming convention!!!

Here I mean to have Colum

UPDATE table_name SET column1 = value1, column2 = value2, columnN = valueN

Here N is 100.

Cheers -

Techi



On Wed, Aug 7, 2013 at 3:26 PM, Hick Gunter <h...@scigames.at> wrote:

> What do you mean by "variable"?
>
> -Ursprüngliche Nachricht-
> Von: techi eth [mailto:techi...@gmail.com]
> Gesendet: Mittwoch, 07. August 2013 10:50
> An: General Discussion of SQLite Database
> Betreff: [sqlite] Query on Update or Selective Insert
>
> Query on Update or Selective Insert:
>
> I am trying to update 100 variables at a time & due to some of the
> reason
> 99 th or any mid index variable cause update to fail.
>
> In that case this query has to execute it again for the entire
> variable or only for failed variable.
>
> Cheers -
>
> Techi
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> --
> 
>  Gunter Hick
> Software Engineer
> Scientific Games International GmbH
> Klitschgasse 2 - 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien
> Tel: +43 1 80100 0
> E-Mail: h...@scigames.at
>
> This e-mail is confidential and may well also be legally privileged.
> If you have received it in error, you are on notice as to its status
> and accordingly please notify us immediately by reply e-mail and then
> delete this message from your system. Please do not copy it or use it
> for any purposes, or disclose its contents to any person as to do so
> could be a breach of confidence. Thank you for your cooperation.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


--
 Gunter Hick
Software Engineer
Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna, Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This e-mail is confidential and may well also be legally privileged. If you 
have received it in error, you are on notice as to its status and accordingly 
please notify us immediately by reply e-mail and then delete this message from 
your system. Please do not copy it or use it for any purposes, or disclose its 
contents to any person as to do so could be a breach of confidence. Thank you 
for your cooperation.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Query on Update or Selective Insert

2013-08-07 Thread techi eth
Apologies to use programming convention!!!

Here I mean to have Colum

UPDATE table_name SET column1 = value1, column2 = value2, columnN =
valueN

Here N is 100.

Cheers -

Techi



On Wed, Aug 7, 2013 at 3:26 PM, Hick Gunter <h...@scigames.at> wrote:

> What do you mean by "variable"?
>
> -Ursprüngliche Nachricht-
> Von: techi eth [mailto:techi...@gmail.com]
> Gesendet: Mittwoch, 07. August 2013 10:50
> An: General Discussion of SQLite Database
> Betreff: [sqlite] Query on Update or Selective Insert
>
> Query on Update or Selective Insert:
>
> I am trying to update 100 variables at a time & due to some of the reason
> 99 th or any mid index variable cause update to fail.
>
> In that case this query has to execute it again for the entire variable or
> only for failed variable.
>
> Cheers -
>
> Techi
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> --
>  Gunter Hick
> Software Engineer
> Scientific Games International GmbH
> Klitschgasse 2 – 4, A - 1130 Vienna, Austria
> FN 157284 a, HG Wien
> Tel: +43 1 80100 0
> E-Mail: h...@scigames.at
>
> This e-mail is confidential and may well also be legally privileged. If
> you have received it in error, you are on notice as to its status and
> accordingly please notify us immediately by reply e-mail and then delete
> this message from your system. Please do not copy it or use it for any
> purposes, or disclose its contents to any person as to do so could be a
> breach of confidence. Thank you for your cooperation.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Query on Update or Selective Insert

2013-08-07 Thread Hick Gunter
What do you mean by "variable"?

-Ursprüngliche Nachricht-
Von: techi eth [mailto:techi...@gmail.com]
Gesendet: Mittwoch, 07. August 2013 10:50
An: General Discussion of SQLite Database
Betreff: [sqlite] Query on Update or Selective Insert

Query on Update or Selective Insert:

I am trying to update 100 variables at a time & due to some of the reason 99 th 
or any mid index variable cause update to fail.

In that case this query has to execute it again for the entire variable or only 
for failed variable.

Cheers -

Techi
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


--
 Gunter Hick
Software Engineer
Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna, Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This e-mail is confidential and may well also be legally privileged. If you 
have received it in error, you are on notice as to its status and accordingly 
please notify us immediately by reply e-mail and then delete this message from 
your system. Please do not copy it or use it for any purposes, or disclose its 
contents to any person as to do so could be a breach of confidence. Thank you 
for your cooperation.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Query on Update or Selective Insert

2013-08-07 Thread techi eth
Query on Update or Selective Insert:

I am trying to update 100 variables at a time & due to some of the reason 99
th or any mid index variable cause update to fail.

In that case this query has to execute it again for the entire variable or
only for failed variable.

Cheers -

Techi
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users