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.
Printable View
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.
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 [email protected] or [email protected] for further clarifications
The Ultimate Solution Providers
Authors
Sriman & Jayaraman
Email : [email protected]
[email protected]
Hand Phone : +(6) 016 2237147
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
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 [email protected] and if u want u can send the sample code u r using.
Ansu