Re: [Gambas-user] Conditional edit of a database table

2016-06-19 Thread zainudin ahmad
It's work as expected with sqlite. attach project - extract into /tmp dir - run On Sun, Jun 19, 2016 at 6:21 PM, wrote: > On 2016-06-18 02:54, Shane wrote: > > Are you looking for something like > > hConn.Find("clients", "firstname LIKE &1 OR lastname LIKE &1 OR phone > > like &1 OR street_name

Re: [Gambas-user] Conditional edit of a database table

2016-06-19 Thread willy
On 2016-06-18 02:54, Shane wrote: > Are you looking for something like > hConn.Find("clients", "firstname LIKE &1 OR lastname LIKE &1 OR phone > like &1 OR street_name LIKE &1 OR suburb LIKE &1", "%" & s & "%") > except with AND'S No, not looking for like queries just a simple: rResult = hConn.Edi

Re: [Gambas-user] Conditional edit of a database table

2016-06-17 Thread Shane
Are you looking for something like hConn.Find("clients", "firstname LIKE &1 OR lastname LIKE &1 OR phone like &1 OR street_name LIKE &1 OR suburb LIKE &1", "%" & s & "%") except with AND'S On 17/06/16 06:45, wi...@develop.earthshipeurope.org wrote: > On 2016-06-16 22:05, Benoît Minisini wrote: >

Re: [Gambas-user] Conditional edit of a database table

2016-06-16 Thread willy
On 2016-06-16 22:05, Benoît Minisini wrote: > Le 16/06/2016 21:10, wi...@develop.earthshipeurope.org a écrit : >> On 2016-06-13 16:45, wi...@develop.earthshipeurope.org wrote: >>> Hi all, >>> >>> I have been editing tables successfully using something like: >>> >>> rResult = hConn.Edit("error", "

Re: [Gambas-user] Conditional edit of a database table

2016-06-16 Thread Benoît Minisini
Le 16/06/2016 21:10, wi...@develop.earthshipeurope.org a écrit : > On 2016-06-13 16:45, wi...@develop.earthshipeurope.org wrote: >> Hi all, >> >> I have been editing tables successfully using something like: >> >> rResult = hConn.Edit("error", "id=&1", iId) >> >> This comes in handy when wanting to

Re: [Gambas-user] Conditional edit of a database table

2016-06-16 Thread willy
On 2016-06-13 16:45, wi...@develop.earthshipeurope.org wrote: > Hi all, > > I have been editing tables successfully using something like: > > rResult = hConn.Edit("error", "id=&1", iId) > > This comes in handy when wanting to edit a record with a certain id and > works just fine for simple cases

[Gambas-user] Conditional edit of a database table

2016-06-13 Thread willy
Hi all, I have been editing tables successfully using something like: rResult = hConn.Edit("error", "id=&1", iId) This comes in handy when wanting to edit a record with a certain id and works just fine for simple cases. But I have a table where the fields id and company (in table error) togeth