[Gambas-user] Conditional edit of a database table

[Benoît Minisini]

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,

-- 
Benoît Minisini