• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 574
  • Last Modified:

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?
0
johnwood
Asked:
johnwood
1 Solution
 
andysalihCommented:
what was the error message ?

Andy

0
 
Éric MoreauSenior .Net ConsultantCommented:
set the adStatus parameter to adStatusCancel in the WillMove event.
0
 
Valliappan ANSenior Tech ConsultantCommented:
May be your cursor type is adOpenForwardOnly. Try setting it to adOpenStatic or adOpenKeySet.

Hope this helps.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now