>>* assume CA is valid and returns a cursor: Temp_.whse, Temp_.prod, Temp_.Inv . >>set multilocks on >>oCA.tag = "Provider=VFPOLEDB.1;Data Source=DATAFILE;Password='';Collating Sequence=MACHINE;" >>oCA.datasourcetype = "ADO" >>oCA.flags = 0 >>oCA.fetchasneeded = .t. >>oCA.prepared = .f. >>oCA.updatecmddatasource = "ADO" >>oCA.selectcmd = "SELECT * FROM Whseprods WHERE Whse = ?cWhse and Prod = ?cProd" >>oCA.KeyFieldList = "WHSE, PROD" >>oCA.UpdateNameList = "WHSE Whseprods.Whse, PROD Whseprods.prod, CALCDEPLOY Whseprods.Calcdeploy" >>oCA.UpdatableFieldList = "CALCDEPLOY" >>oCA.Tables = "Whseprods" >>oCA.SendUpdates = .T. >>cWhse = "W1" >>cProd = "P1" >>oCA.RefreshCursor() >>replace temp_.inv with 100 >>skip && is the record updated back to the base table here? >>* with views I can issue a TABLEUPDATE() to send the updates, is there something I have to call? >>>>