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