ADODC Update Issue

[karateboy02]

I am having a problem with an adodc update. I use the adodc.recordset.update command and it works perfectly on every field that is edited by mouse click. It doesn't matter if it is a check box or a text box. However if I change the value in my code such as:

If textbox1.text = "1" then
textbox1.text = "0"
adodc1.recordset.update
end if

It never updates that record in the database. Any sugestions?

 

[tedsmith]

I seem to remember it only updates when you move away from the record or you have to have I think a adodc1.recordset.refresh or something like that.
I used to make it movenext and moveprevious to be sure unless it was at the end when I would do in in the reverse.

 

[karateboy02]

If I do a refresh then it will just pull the data already in the record which is not the data I want and does not do an update. Also I cannot move to another record because it is the only record in the recordset.

 

[fredericofonseca]

In order to avoid many headaches in your future I advise you not to use the ADODC control at all, and to use plain ADODB and code to retrieve, populate your forms, and then update the database back.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[SBerthold]

adodc1.recordset.Fields(textbox1.DataField).Value="0"
adodc1.recordset.update

 

[karateboy02]

adodc1.recordset.Fields(textbox1.DataField).Value="0"
adodc1.recordset.update


This works perfectly, thank you very much.