[Gambas-user] Conditional edit of a database table

[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, <willy at ...3474...> 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 LIKE &1 OR suburb LIKE &1", "%" & s & "%")
> > except with AND'S
>
> No, not looking for like queries just a simple:
> rResult = hConn.Edit("error", "id=&1 AND company=&2", iId, sCompany)
>
> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test-db-2Pk.tar.gz
Type: application/x-gzip
Size: 12062 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20160620/b03aa979/attachment.bin>