adLockReadOnly

Hi Experts,

A Text box is bound to an ADODC, the ADODC's LockType=adLockReadOnly.
In run time, when edit the text in the Text box and then tried to move to next record, an error message appeared and the record was restored automatically. Ok, fine. But since then, I just cannot move to other records.
What I should do so that after ADODC gives an error message and restores the record, users can continue move to other record?
johnwoodAsked:
Who is Participating?
 
Valliappan ANConnect With a Mentor Senior Tech ConsultantCommented:
May be your cursor type is adOpenForwardOnly. Try setting it to adOpenStatic or adOpenKeySet.

Hope this helps.
0
 
andysalihCommented:
what was the error message ?

Andy

0
 
Éric MoreauSenior .Net ConsultantCommented:
set the adStatus parameter to adStatusCancel in the WillMove event.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.