The minimal code needed to use CGrid View is as follows: instance.The displayed table is equiped with sorting and pagination functionality. Some values may have been changed since it was last read." I don't understand why all the previous updates worked fine and this one fails.
In the next section we will take a closer look at ADO's batch updates, what they can offer you, and why they are so important.
Some values may have been changed since it was last read." The Table1 and Table2 have a primary key in the grid. str SQL = _ "SELECT" & _ "[Table1].*," & _ "[Table2].* " & _ "FROM [Table1] " & _ "LEFT JOIN [Table2] " & _ "ON [Table1]. Recordset Load form event I have this: Set Cmd Edit = New ADODB.
If I update one record and then move to a new record and try to update I get that error. Active Connection = Conn Addtxt Set rs Edit = New ADODB.
However, in this section you won't need them to solve the problem of updating a join, because in ADO, joins are naturally updatable.
For example, the Join Data example is built around an ADODataset component that uses the previous SQL join.