Re: [sqlite] UPDATE base on certain values

2007-03-10 Thread jose isaias cabrera
"Dennis Cote" wrote, jose isaias cabrera wrote: So, there is on way of doing it in one call/instruction as I previously exampled, correct? I will have to do them in many calls, correct? Jose, You can do it in one API call if you put all the update statements into a single string. Yo

Re: [sqlite] UPDATE base on certain values

2007-02-13 Thread Dennis Cote
jose isaias cabrera wrote: So, there is on way of doing it in one call/instruction as I previously exampled, correct? I will have to do them in many calls, correct? Jose, You can do it in one API call if you put all the update statements into a single string. You will probably also wan

Re: [sqlite] UPDATE base on certain values

2007-02-13 Thread Clark Christensen
AIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, February 13, 2007 12:29:25 PM Subject: Re: [sqlite] UPDATE base on certain values On 2/13/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote: > > "P Kishor" wrote, > > > On 2/13/07, jose isaias cabrera <[E

Re: [sqlite] UPDATE base on certain values

2007-02-13 Thread jose isaias cabrera
"P Kishor" wrote, On 2/13/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote: "P Kishor" wrote, > On 2/13/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote: >> >> Greetings! >> >> I would like to be able to update certain columns based on their >> value. >> I >> was looking at "ON CONFLICT

Re: [sqlite] UPDATE base on certain values

2007-02-13 Thread P Kishor
On 2/13/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote: "P Kishor" wrote, > On 2/13/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote: >> >> Greetings! >> >> I would like to be able to update certain columns based on their value. >> I >> was looking at "ON CONFLICT", but I could not understa

Re: [sqlite] UPDATE base on certain values

2007-02-13 Thread jose isaias cabrera
"P Kishor" wrote, On 2/13/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote: Greetings! I would like to be able to update certain columns based on their value. I was looking at "ON CONFLICT", but I could not understand it nor I could not find any examples quickly, so I say, "heck, that's w

Re: [sqlite] UPDATE base on certain values

2007-02-13 Thread P Kishor
On 2/13/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote: Greetings! I would like to be able to update certain columns based on their value. I was looking at "ON CONFLICT", but I could not understand it nor I could not find any examples quickly, so I say, "heck, that's what the list is for...

[sqlite] UPDATE base on certain values

2007-02-13 Thread jose isaias cabrera
Greetings! I would like to be able to update certain columns based on their value. I was looking at "ON CONFLICT", but I could not understand it nor I could not find any examples quickly, so I say, "heck, that's what the list is for..." :-) What I would like is to do something like this,