I have a new form with the ActiveX Data Objects DataControl and DataGrid.
As a test I tried to set AllowUpdate to true.
When I try to change values in the grid I notice two things...
1)I can't type anything in any fields
2)I can copy and paste a field value to another field
But when I leave the change field I get the message:
"Insufficient base table insformation for updating or refreshing"
Is there someway to get this to work.
Also:
1)Does it implicitly lock the record when you edit?
2)If I set on AllowDelete how do you actually delete something from the grid.
this.connectionstring="Provider=VFPOLEDB.1;Data Source=C:\363\data\;Collating Sequence=MACHINE"
this.RecordSource="select * from C:\363\data\article"
with ThisForm.datagrid
.Datasource = This.object
endwith