CdataSet is a block of cCell consisting of a collection of cDataRow, with an abstraction of a collection of cDataColumn The sid argument refers to the column either by column name or number and the rowID refers to the particular row by number, or by name if labels have been enabled when the data set was created. Where both sid and rowid are optional and omitted the complete dataset is operated on. if one or the other is omitted, then the referenced cDataColumn or cDataRow is operated on. Where both sid and rowID are present the cCell they address in the cDataSet is operated on.
cDataSet.Refresh() will refresh the entire dataset, and cDataSet.cells(“London”,”Area”).value or cDataSet.rows(“london”).cell(“Area”).value would return a single cell.
cDataColumn.Refresh will refresh the entire column, and cDataColumn(“South”).Refresh or cDataColumn(22)would refresh a single cell. In other words,cDataColumn(201).Refreshis equivalentto cDataColumn(201).Cell.Refresh