Re: adodc update




"casiopea" <casiopea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C57A38F2-09AD-4778-964E-1F13BEA9392F@xxxxxxxxxxxxxxxx
> I've got a text box associated to an adodc control. The problem is the
> following:
> adoentry is an adodc control; if I use adoentry.update and I have changed
> the value of the text control associated to a field, it doesn't save it;
> however if I directly use adoentry.movenext or adoentry.moveprevious it
> saves
> it.
> I have also try with adoentry.recordset.resync and it doesn't work either.
> Any tips?

If you want to force data-bound controls to update the datasource, without
changing the record position, set the bookmark property to itself.
Personally I *never* use ADODC, it's too easy to write your own data source
controls, and much more flexible... but the principle is the same.

If ADODC has a bookmark property, assign it to itself, otherwise use the
underlying recordset's bookmark property, e.g.,

adoentry.recordset.Bookmark = adoentry.recordset.Bookmark

-Mark


.



Relevant Pages

  • Re: datagrid updating from join to single table
    ... You need to create your own custom data class or user control. ... You will then have control of the recordset that ... > using a datagrid and ADODC control as it's datasource. ...
    (microsoft.public.data.ado)
  • RE: adodc_Validate(action As Integer, save As Integer) fails to fire
    ... the Textbox or other databinding controls, however the Adodc control ... can cacel the Unload operation by setting the "Cancel" parameter. ... the Validate - sub ...
    (microsoft.public.vb.database.ado)
  • Re: DataCombo boxes and ADODCs.
    ... a typical situation where the disadvantages of Data Binding outweigh the ... Most programmers I know are control freaks. ... manually change the RecordSet position ... > property that is an ADODC control, and I want the new control to ...
    (microsoft.public.vb.general.discussion)
  • DataGrid control displaying blank first cell when bounded with ADO
    ... The ADODC control is connected to an Microsoft Access Database using Jet.OLEDB4.0 provider. ... the first cell in the DataGrid control is always shown as blank. ...
    (microsoft.public.vc.mfc)
  • Re: Controlling another forms recordset
    ... Once you have a form object, you use the Bookmark property to select a ... I tried several ways to control the other forms recordset. ... I prefer not to use globals if they can be avoided. ...
    (microsoft.public.access.modulesdaovba)