update ado recordset 
Author Message
 update ado recordset

Which database are you using


Quote:
> Dear all,

> When I change a field which is on a form, and I update
> with the ..recordset.update command, it seems that the
> data is not immediatly transfered in the db.

> I have to move one record next and forward to see the new
> content of the field on my reports. Is this due to some
> kind of caching?

> Thanks for you help
> Marc



Tue, 26 Apr 2005 21:31:43 GMT
 update ado recordset

You may have to Requery the db to get the updated info

RC


Quote:
> Dear all,

> When I change a field which is on a form, and I update
> with the ..recordset.update command, it seems that the
> data is not immediatly transfered in the db.

> I have to move one record next and forward to see the new
> content of the field on my reports. Is this due to some
> kind of caching?

> Thanks for you help
> Marc



Tue, 26 Apr 2005 21:50:33 GMT
 update ado recordset
Dear all,

When I change a field which is on a form, and I update
with the ..recordset.update command, it seems that the
data is not immediatly transfered in the db.

I have to move one record next and forward to see the new
content of the field on my reports. Is this due to some
kind of caching?

Thanks for you help
Marc



Tue, 26 Apr 2005 21:10:04 GMT
 update ado recordset
You must use requery (or refresh) command, as stated in
previous message.

A different approach could'be as follows.

Sub Form_Unload(Cancel)

  if myRecordset.RecordCount<>0 then myRecordset.MoveFirst
  myRecordset.Close

End Sub

Hope this helps

Giuseppe

Quote:
>-----Original Message-----
>Dear all,

>When I change a field which is on a form, and I update
>with the ..recordset.update command, it seems that the
>data is not immediatly transfered in the db.

>I have to move one record next and forward to see the new
>content of the field on my reports. Is this due to some
>kind of caching?

>Thanks for you help
>Marc
>.



Wed, 27 Apr 2005 00:03:12 GMT
 update ado recordset
hello,
it is an access DB and access it through ado code and ocx
thanks,
Marc
Quote:
>-----Original Message-----
>Which database are you using



>> Dear all,

>> When I change a field which is on a form, and I update
>> with the ..recordset.update command, it seems that the
>> data is not immediatly transfered in the db.

>> I have to move one record next and forward to see the
new
>> content of the field on my reports. Is this due to some
>> kind of caching?

>> Thanks for you help
>> Marc

>.



Fri, 29 Apr 2005 03:17:04 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Problem updating ADO recordset

2. Problems Updating ADO Recordset

3. Update ADO recordset and ComboBox

4. Can't Update ADO Recordset when Select has Computed column

5. Unable to update ADO Recordset

6. handling error when update ADO Recordset (VB6, ADO2.5, SQL 7)

7. Updating ADO Recordset

8. Updating ADO recordset with more than 40 columns

9. Timeout with updating ADO.Recordset MS SQL 7.0/Access 97

10. Updating ADO Recordsets (with Dataenvironment)

11. Problems Updating ADO Recordset

12. Can't Update ADO Recordset when Select has Computed column


 
Powered by phpBB® Forum Software