Re: [sqlite] Updating only the last raw

2008-10-17 Thread Igor Tandetnik
"Lloyd" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Lets assume a table having following data > > No. Name Address > > 1 A addrA > 2 B addrB > 3 C addrC > 4 B addrB1 > > I want to update the filed 'Address' based on field 'Name'. But if > there are multipl

Re: [sqlite] Updating only the last raw

2008-10-17 Thread Lloyd
Thank you very much Dan. On Fri, 2008-10-17 at 14:10 +0700, Dan wrote: > On Oct 17, 2008, at 1:43 PM, Lloyd wrote: > > > Hi, > > > > Lets assume a table having following data > > > > No. NameAddress > > > > 1 A addrA > > 2 B addrB > > 3 C addrC

Re: [sqlite] Updating only the last raw

2008-10-17 Thread Dan
On Oct 17, 2008, at 1:43 PM, Lloyd wrote: > Hi, > > Lets assume a table having following data > > No. NameAddress > > 1 A addrA > 2 B addrB > 3 C addrC > 4 B addrB1 > > I want to update the filed 'Address' based on field 'Name

[sqlite] Updating only the last raw

2008-10-16 Thread Lloyd
Hi, Lets assume a table having following data No. NameAddress 1 A addrA 2 B addrB 3 C addrC 4 B addrB1 I want to update the filed 'Address' based on field 'Name'. But if there are multiple table entries (The case of