concurrency violation error

[Agnes]

I got a simple form and using databinding manager to do the add new
Now , my big trobule is . I can update the 'addnew' record, However, after I
new the record, and then amend it , it got concurrency violation error, (I
can solve it but I need to clear the dataset and fill in again, and I think
it is not the solution)
Please help

 

[Agnes]

I should post my code here:-
I am using Databinding manager to bind the textbox in the form.
'New
bmInvoice.endcurrent()
bmInvoice.addnew()
'Save...
if dsInvoice.haschanges() then
daInvoice.update(dsInvoice,"invoicetable")
dsInvoice.update()
end if

'Modify
bmInvoice.endcurrent()
'Save.....
if dsInvoice.haschanges() then
daInvoice.update(dsInvoice,"invoicetable")
dsInvoice.update()
end if

Now , I can save the record (in new mode) , however, once I modify it
immedately and then save, I got 'concurrency violation ; update command
affect 0 records' ?
Please help

 

[Cor Ligthert]

Agnes,

I think your code is not needed only to tell if you use "autokey".

Before you think it, that is when you get these problems and I have no
"better" solution than the one you use.

Cor

I should post my code here:-
I am using Databinding manager to bind the textbox in the form.
'New
bmInvoice.endcurrent()
bmInvoice.addnew()
'Save...
if dsInvoice.haschanges() then
daInvoice.update(dsInvoice,"invoicetable")
dsInvoice.update()
end if

'Modify
bmInvoice.endcurrent()
'Save.....
if dsInvoice.haschanges() then
daInvoice.update(dsInvoice,"invoicetable")
dsInvoice.update()
end if

Now , I can save the record (in new mode) , however, once I modify it
immedately and then save, I got 'concurrency violation ; update command
affect 0 records' ?
Please help