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
