Query.Execute

Syntax:

Execute()

Returned value:

Type: QueryResult; Undefined.
The result of execution query to delete the temporary table is the Undefined value.

Description:

Executes the database query.
If a query is set to the batch query, the method executes all queries from the batch sequentially and returns the result of the last query from the batch, which does not create or delete a temporary table. If there is no such a query, then method returns result of the last query.

Availability:

Server, thick client, external connection, Mobile application (server).

Note:

If an incorrect query is executed the exceptions text will contain the number of the line where the error was detected.

Example:

Query = New Query("SELECT
         | Incomes.Ref
         |FROM
         | Catalog.Incomes AS Incomes
         |
         |WHERE
         | (Incomes.Predefined)"
);
Result = Query.Execute();


    

1C:Enterprise Developer's Community