[RESOLVED] DataGrid Problem

Hi all,

I make a simple form in VB6 to input / edit Personal data.
I use one Adodc and some commandbutton and text box.

Everything is ok ( I can Add new, cancel , edit, etc).

Then I add a Datagrid to the form only to show ID and Name.
I use one Adodc for all of them.

Everything is ok, except one :
If I add a new record ( adodc1.recordset.addnew), then
I cancel it ( adodc1.recordset.cancelUpdate ) , an error message appear :
... they would create duplicate value in index, primary key ........

My database have primary dan index, but in this case I don't make any new record.

Can anyone please tell me how to avoid this error ?

Thank you
Rudy Ong

What is the Cursor Type You are Using?

I use OpenDynamic.

Try the lock type as LockBatchOptimistic

http://home.rochester.rr.com/lgsstatic/welcome.gif

check out the Database Faq section:

http://www.vbforums.com/showthread.php?t=337051

Thank you.
It is working now.


Rudy Ong