[Gambas-user] Conditional edit of a database table

[willy at ...3474...]

On 2016-06-16 22:05, Benoît Minisini wrote:
> Le 16/06/2016 21:10, willy at ...3474... a écrit :
>> On 2016-06-13 16:45, willy at ...3474... 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