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

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

Re: [sqlite] Query on Update or Selective Insert

2013-08-07 Thread Hick Gunter
[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

Re: [sqlite] Query on Update or Selective Insert

2013-08-07 Thread techi eth
"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 Inse

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

[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