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: >> 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 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) >>>> together form the primary key. >>>> >>>> My question: Is it possible to edit a record based on these two >>>> requirements using db.edit function? >>>> >>>> Something like below doesn't seem to work: >>>> >>>> rResult = hConn.Edit("error", "id=&1 AND company=&2", iId, sCompany) >>>> >>>> and documentation (http://gambaswiki.org/wiki/comp/gb.db/db/edit) >>>> isn't >>>> really helpful. >>>> >>>> Thanks, >>>> >>>> gbWilly >>> Anyone a sensible answer? >>> >>> gbWilly >>> >> It should work. Please post a project with the code that does not work >> as expected. >> >> Regards, > Well, as usual it is part of a bigger application. > So, I'll try to make a small example and post it when ready. > > Thanks for the response, > > gbWilly > > ------------------------------------------------------------------------------ > What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic > patterns at an interface-level. Reveals which users, apps, and protocols are > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > J-Flow, sFlow and other flows. Make informed decisions using capacity planning > reports. http://sdm.link/zohomanageengine > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohomanageengine _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user