> > This.DataSource = this.oRS > this.oCommand = CREATEOBJECT("ADODB.COMMAND") > This.UpdateCmdDataSource = this.oCommand > This.oRS.ActiveConnection = this.oConn > this.oCommand.ActiveConnection = this.oConn > >>
>>Check UpdateCmdDataSource in help: >> >>"ADO" UpdateCmdDataSource must be set to a valid ADO Command object. >> The ActiveConnection property of the ADO Command object must be set to a valid and open ADO Connection object. >> >> Visual FoxPro sets the CommandText property of the ADO Command object to the value of the CursorAdapter UpdateCmd property. >> Visual FoxPro parses the command for parameters, creates parameter values if found, and sets them in the Command object. >> >> The update operation occurs as: >> CursorAdapter.UpdateCmdDataSource.Execute() >> >> For more information about using an ADO RecordSet, automatic updating, and generating SQL commands automatically, see Data Access Management Using CursorAdapters >>