Open - method of object PmDatabase
true - If opening the database and its table passed successfully
false - Otherwise
The table is opened or the SQL statement SELECT
is executed as per setting the Type
properties (the initial values are taken over from the configurators on the Database
page of this object).
Vice versa if this configurator is not checked.
'... do something with the table Table1
'... do something with the table Table2
oDb.OpenSQL = "SELECT * FROM Table WHERE MyColumn BETWEEN 10 AND 100"
'... do something with the query "SELECT * FROM Table ..."
oDb.OpenSQL ="SELECT MyColumn1, MyColumn2 FROM Table WHERE MyColumn1 > 10"
'... do something with the query "SELECT MyColumn1, MyColumn2 FROM Table ..."