ODAC

TOraSQL Properties

Properties of the TOraSQL class.

For a complete list of the TOraSQL class members, see the TOraSQL Members topic.

Public

Name Description

ArrayLength

Used to set the Length propery to all parameters.

ChangeCursor (inherited from TCustomDASQL)

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

Connection (inherited from TCustomDASQL)

Used to specify a connection object to use to connect to a data store.

Debug (inherited from TCustomDASQL)

Used to display the statement that is being executed and the values and types of its parameters.

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.

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.

ParamValues (inherited from TCustomDASQL)

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

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.

RowsProcessed

Used to return the number of rows processed by a SQL statement.

SQL (inherited from TCustomDASQL)

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

SQLType

Used to get the typecode of the SQL statement being processed by an Oracle database server.

Published

Name Description

CommandTimeout

Sets the wait time before a request is sent to the server to terminate the attempt to execute or fetch the current SQL statement.

NonBlocking

Used to execute a SQL statement by a separate thread.

Params

Contains the parameters for a SQL statement.

Session

Used to define the session to execute SQL in.

StatementCache

Used to get a value indicating whether Oracle resources assosiated with the current statement will be cached inside a session.

TemporaryLobUpdate

Specifies whether to use temporary LOBs for writing input and input/output LOB parameters into database when executing SQL statements.

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback