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!

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

visual basic

Status
Not open for further replies.

tekbond007

Programmer
Aug 7, 2001
16
IN
hai intels,
Can any of u answer to this question
How to know whether a record is updated sucessfully of not after rs.update() call
will it return something


Expecting ur answer


Thanx
vijay
 
Clear all of the text boxes, and them immediately edit the record you just inserted. This would be very annoying to the user, but during the design phase you could implment this for consistent update verification, and then remove it when you roll out your code.
 


Hi tekbond007


Dont really know from practal experience, but I think that typical errors and conflicts are detected and errrors are reported.

That is the point of commit/rollback when you have to do UpdateBatch.


Stew




 
I usually check the "RowsAffected" property of the recordset object.

Thanks,
Kevin Yearian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top