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

Concurrency violation problem

P: n/a
i got an invoice table, its primary key is recid, I set it in SQL server 's
table, (set identity (yes),indentity seed (1),indentity increment(1))
Step(1)Now, in my "btnNew" button,
bmInvoice.endcurrentedit(),bmInvoice.addnew(),
in my"btnSave",
bmInvoice.endcurrentedit()
if dsInvoice.haschanges() then
daInvoice.update(dsInvoice,"invoicetable")
dsInvoice.accpetchanges
end if

Step(2) in my 'btnMoidfy" , bmInvoice.endcurrentedit(), then I process
'btnSave' again,
Problem , I found that After Step(1), the primary key recid got nothing in
it. IF I 'modify' the record and perform 'btnSave' again, I will got
'CONCURRENCY VIOLTATION, UPDATE COMMAND 0 RECORDS',
If I quit the form, run it again, I can Modify and save my record, What's
wrong ???
please help ~~
Nov 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.