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


------------------------------------------------------------------------------
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. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user

Reply via email to