Executes the SQL script for the recordset.


The parameters of the ExecSql method are based on the SQL input parameters as defined in VenturaSQL Studio.The parameter list is defined on the recordset editor page.


SQL parameters are always nullable.


If the connector parameter is not specified, ExecSql will use the VenturaConfig.DefaultConnector


void ExecSql()

The VenturaConfig.DefaultConnector will be used.


No SQL input parameters.

void ExecSql(parameters)

 The VenturaConfig.DefaultConnector will be used.


parameters

One or more parameters.

void ExecSql(Connector connector)

connector (Connector)

The connector to use.


No SQL input parameters.

void ExecSql(Connector connector, parameters)

connector (Connector)

The connector to use.


parameters

One or more parameters. The VenturaConfig.DefaultConnector will be used.


Asynchronous

The async version of ExecSql is named ExecSqlAsync.


See topic Executing the SQL script for more information.

The Input and Output parameters document provides an in-depth explanation of Ventura's SQL parameters concept.


This method is defined in the generated recordset code.


public void ExecSql(int? CustomerNumber)

public void ExecSql(Connector connector, int? CustomerNumber)

public async Task ExecSqlAsync(int? CustomerNumber)

public async Task ExecSqlAsync(Connector connector, int? CustomerNumber)


Remarks

Recordset.ExecSql(...)


is equivalent to


Recordset.SetSqlParams(...) 

Transactional.ExecSql(Recordset)