Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating records

Status
Not open for further replies.
Wallegator

Wallegator

Programmer
Jan 3, 2001
58
US
I have a VB application that is linking to an SQL table via adodc1. The SQL table has one record in it and one field. I want to change its value. I make the change and close the form. When I reopen the value has not changed. I've tried adodc1.Recordset.UpdateBatch on both the Change and Lost Focus properties of the control. No luck.

Any clue what I am doing wrong? Thank you in advance.



 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
FILL RICHTEXTBOX WITH RECORDSET
Replies
4
Views
535
strongm
strongm
sal21
  • Locked
  • Question
UPDATE DAO RECORDSET 1
Replies
11
Views
795
strongm
strongm
mjassalina
  • Locked
  • Question
Add new record instead of Updating only
Replies
3
Views
275
mjassalina
mjassalina
sal21
  • Locked
  • Question
fill array from recordset
Replies
6
Views
846
2009luca
2009luca
Franka71
  • Locked
  • Question
Connecting to a Disconnected Recordset...
Replies
1
Views
312
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top