ExecuteSQL - method of object PmDatabase
It executes the SQL statement in the database defined by the Database
property. The method can be called if the PmDatabase
object was connected
to the database, for example, by calling the Connect
ExecuteSQL(sSQL As String) As Long
n = oDb.ExecuteSQL(sSQL)
|sSQL||(String) Statement in the SQL language syntax|
By this method the statement that returns the set of rows (e.g. the SELECT statement), can't be executed.
If the statement failed, then the method returns the value -1.
If the Technology
configurator is set to Access through ODBC
and the statement passed successfully, then the method returns the value 0
. The SQL statement in the method must comply with the syntax of the database to which the object is connected.