By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,302 Members | 1,812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,302 IT Pros & Developers. It's quick & easy.

concurrency violation error

P: n/a
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

--
..
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

--
..
"Agnes" <ag***@dynamictech.com.hk> 在郵件
news:OL**************@tk2msftngp13.phx.gbl 中撰寫...
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

--
.

Nov 21 '05 #2

P: n/a
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

"Agnes" <ag***@dynamictech.com.hk>

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

--
.
"Agnes" <ag***@dynamictech.com.hk> 在郵件
news:OL**************@tk2msftngp13.phx.gbl 中撰寫...
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

--
.


Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.