SDAC

TMSSQL Members

TMSSQL class overview.

Properties

Name Description

ChangeCursor (inherited from TCustomDASQL)

Enables or disables changing screen cursor when executing commands in the NonBlocking mode.

CommandTimeout

Used to specify the wait time before terminating the attempt to execute a command and generating an error.

Connection

Used to specify a connection object that will be used to connect to a data store.

Debug (inherited from TCustomDASQL)

Used to display executing statement, all its parameters' values, and the type of parameters.

DescribeParams

Used to specify whether to query TMSParam properties from the server when executing the TCustomDASQL.Prepare method.

FinalSQL (inherited from TCustomDASQL)

Used to return a SQL statement with expanded macros.

MacroCount (inherited from TCustomDASQL)

Used to get the number of macros associated with the Macros property.

Macros (inherited from TCustomDASQL)

Makes it possible to change SQL queries easily.

NonBlocking

Used to execute a SQL statement in a separate thread.

ParamCheck (inherited from TCustomDASQL)

Used to specify whether parameters for the Params property are implicitly generated when the SQL property is being changed.

ParamCount (inherited from TCustomDASQL)

Indicates the number of parameters in the Params property.

Params

Contains parameters for a query's SQL statement.

ParamValues (inherited from TCustomDASQL)

Used to get or set the values of individual field parameters that are identified by name.

PermitPrepare

This option is not supported any more.

Prepared (inherited from TCustomDASQL)

Used to indicate whether a query is prepared for execution.

RowsAffected (inherited from TCustomDASQL)

Used to indicate the number of rows which were inserted, updated, or deleted during the last query operation.

SQL (inherited from TCustomDASQL)

Used to provide a SQL statement that a TCustomDASQL component executes when the Execute method is called.

Methods

Name Description

Execute (inherited from TCustomDASQL)

Overloaded. Executes a SQL statement on the server.

ExecuteForXML

Overloaded. Provides data in readable view for the SELECT statements written using the FOR XML clause.

Executing (inherited from TCustomDASQL)

Checks whether TCustomDASQL still executes a SQL statement.

FindMacro (inherited from TCustomDASQL)

Searches for a macro with the specified name.

FindParam

Determines if a parameter with the specified name exists in a dataset.

MacroByName (inherited from TCustomDASQL)

Finds a Macro with the name passed in Name.

ParamByName

Sets or uses parameter information for a specific parameter based on its name.

Prepare (inherited from TCustomDASQL)

Allocates, opens, and parses cursor for a query.

UnPrepare (inherited from TCustomDASQL)

Frees the resources allocated for a previously prepared query on the server and client sides.

WaitExecuting (inherited from TCustomDASQL)

Waits until TCustomDASQL executes a SQL statement.

Events

Name Description

AfterExecute (inherited from TCustomDASQL)

Occurs after a SQL statement has been executed.
© 1997-2019 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback