Icon Execute Method

function Execute(const SQL: String; Params: TParams=nil; Query:
      TEDBQuery=nil): Integer

Usage

Call the Execute method to execute an SQL statement directly. The number of rows affected is returned as the result of this method. The SQL statement may also be parameterized. Any SQL statement executed using this method is automatically executed from the context of the system-created Configuration database. This makes this method ideal for creating objects in the Configuration database.

Information You may pass in a TEDBQuery component that has already been created for use with this method. However, in such a case you should be aware that several properties of the TEDBQuery component will be overwritten by this method in order to execute the SQL.
Image