ExecuteSQL - method of the PmaDatabase object
It executes the SQL statement in the database defined by the Database
property. The method can be called if the PmaDatabase
object was connected
to the database, for example, by calling the Connect
Long ExecuteSQL(String 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.
sSql = "Statement in the SQL language syntax";