VB - Database Updating

[jplenhart]

When I set a record in my database equal to some value why does it reflect that value whether or not I "update" the recordset. Can someone please shed some light as to what an update actually does???

Thanks in advance.

[askus]

Possible Causes

Are u using a Data Binding (using Data Control). If yes once u move ur record pointer after any changes ur changes are automatically updated,

If u dont use Data binding pl be clear on ur question

please get back to solutionproviders@hotmail.com or solutionproviders@yahoo.com for further clarifications

The Ultimate Solution Providers

Authors

Sriman & Jayaraman

Email : solutionproviders@hotmail.com
solutionproviders@yahoo.com

Hand Phone : +(6) 016 2237147

[shallowborne]

if you are not bound to the data control use this method of "edit" and "update" to change data in a field in the database:
Data1.Recordset.Edit
Data1.Recordset.Fields("FieldName") = ChangedValue
Data1.Recordset.Update

[ansuman_behera]

You might not be using BeginTrans and CommitTrans in which case the program by default commits all ur data 2 the database.
If this does not solve ur problem, then u can send me a question at ansuman_behera@hotmail.com and if u want u can send the sample code u r using.

Ansu