s = oDb.OpenSQL
The property is used by calling the Open method only if the "Open using the SQL statement SELECT" configurator is checked. Otherwise the Table property is used and the whole content of the table is read.
If oDb.IsOpen() Then
oDb.CloseTable
End If
oDb.OpenSQL = "SELECT * FROM Table WHERE MyColumn BETWEEN 10 AND 100"
oDb.Open
'... do something with the query "SELECT * FROM Table ..."
oDb.CloseTable
oDb.OpenSQL = "SELECT MyColumn1, MyColumn2 FROM Table WHERE MyColumn1 > 10"
oDb.Open
'... do something with the query "SELECT MyColumn1, MyColumn2 FROM Table ..."