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