[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] Reference for unit 'sqldb' (#fcl)

TSQLQuery.DataSource

Source for parameter values for unbound parameters

Declaration

Source position: sqldb.pp line 669

published property TSQLQuery.DataSource : TDataSource;

Description

Datasource can be set to a dataset which will be used to retrieve values for the parameters if they were not explicitly specified.

When Open or ExecSQL is called, and the Datasource property is not Nil then for each parameter for which no value was explicitly set (its Bound property is False), the value will be retrieved from the dataset connected to the datasource.

For each parameter, a field with the same name will be searched, and its value and type will be copied to the (unbound) parameter. The parameter remains unbound.

See also

Params

  

Parameters detected in the SQL statement.

ExecSQL

  

Execute a SQL statement that does not return a result set

UsingParams

  

Using parameters

TParam.Bound

  

Is the parameter value bound (set to fixed value)


Documentation generated on: Sep 28 2017