Data.SqlExpr
From RAD Studio API Documentation
Defines classes that implement functionality to work with SQL blob streams, data links, connections, SQL datasets, monitors, queries, server methods and stored procedures, SQL tables, and more.
| Package | dbexpress250.bpl |
|---|
Contents
Classes
SPParamDesc SPParamDesc describes a parameter to a stored procedure that is accessed using dbExpress.
TConnectionData Class used to hold information about the connection.
TCustomSQLDataSet TCustomSQLDataSet is the base class for all dbExpress dataset components.
TFLDDesc Field description wrapper.
TSQLBlobStream TSQLBlobStream lets applications read from or write to BLOB fields in a client dataset.
TSQLConnection TSQLConnection encapsulates a dbExpress connection to a database server.
TSQLDataLink TSQLDataLink allows a unidirectional dataset act as the detail in a master/detail relationship.
TSQLDataSet TSQLDataSet represents data retrieved using dbExpress.
TSQLMonitor TSQLMonitor intercepts messages that pass between an SQL connection component and a database server and saves them in a string list.
TSqlServerMethod TDataSet to call DataSnap server methods and retrieve results from them.
TSQLStoredProc TSQLStoredProc represents a stored procedure that is executed using dbExpress.
TTransactionItem (deprecated) Class used for managing SQL transactions.
Routines
FreeProcParams Frees a list of procedure parameters that is allocated by GetProcedureParams.
GetConnectionNames Populates a string list with the names of all the available connections.
GetConnectionRegistryFile Fills a string with the content of the connection registry file.
GetDelegateDriverNames Populates a string list with the names of drivers for the delegate connections.
GetDriverNames Populates a string list with the names of all available dbExpress drivers.
GetDriverRegistryFile Fills a string with the content of the driver registry file.
LoadParamListItems Fills a TParams object with information from a list of parameter descriptors.
Types
EConnectFlag Represents a connection flag.
SQLResult SQLResult is the return type for dbExpress function calls.
TConnectionUserType Enumeration for user type connections.
TFieldDescList Array of TFLDDesc.
TGetDriverFunc C++ implementation for getting the driver's functions.
TLocaleCode TLocaleCode identifies a locale, which imposes a sort order on data.
TParseInsertSqlEvent C++ definition of the ParseInsertSql event.
TParseSqlEvent C++ definition for parse SQL events of TCustomSQLDataSet.
TSchemaType TSchemaType and TSchemaInfo describe schema information (metadata) to access using dbXpress.
TSQLConnectionLoginEvent C++ definition of the OnLogin event.
TSQLExceptionType TSQLExceptionType indicates the type of operation that leads to an ESQLException exception.
TSQLSchemaInfo Record that indicates whether the dataset represents metadata from the server, and, if so, what kind.
TTableScope Indicates the types of tables for which to fetch metadata.
TTableScopes Set of TTableScope that indicates the types of tables for which to fetch metadata.
TTraceEvent C++ definition of the OnTrace event.
TTraceLogEvent C++ definition of the OnLogTrace event.
TTransactionDesc Transaction description record.
TTransIsolationLevel This enumerated type (in C++) or type (in Delphi) identifies degree to which transactions are isolated from each other.
Variables
BlobTypeMap Maps the blob fields types.
FldSubTypeMap Maps the field's subtypes.
FldTypeMap Maps the field's types.
Constants
DefaultCursor DefaultCursor: Integer = 0;
DefaultMaxBlobSize DefaultMaxBlobSize: Integer = $FFFFFFFF;
DefaultRowsetSize DefaultRowsetSize: Integer = 14ドル;
eSQLAutoIncr eSQLAutoIncr: Integer = 4;
eSQLDefault eSQLDefault: Integer = 8;
eSQLFunction eSQLFunction: Integer = 2;
eSQLLocal eSQLLocal: Integer = 20ドル;
eSQLNonUnique eSQLNonUnique: Integer = 1;
eSQLPackage eSQLPackage: Integer = 4;
eSQLPrimaryKey eSQLPrimaryKey: Integer = 4;
eSQLProcedure eSQLProcedure: Integer = 1;
eSQLRowId eSQLRowId: Integer = 1;
eSQLRowVersion eSQLRowVersion: Integer = 2;
eSQLSynonym eSQLSynonym: Integer = 8;
eSQLSysProcedure eSQLSysProcedure: Integer = 8;
eSQLSystemTable eSQLSystemTable: Integer = 4;
eSQLTable eSQLTable: Integer = 1;
eSQLTempTable eSQLTempTable: Integer = 10ドル;
eSQLUnique eSQLUnique: Integer = 2;
eSQLView eSQLView: Integer = 2;
HourGlassCursor HourGlassCursor: Integer = $FFFFFFF5;
SAnd SAnd: string = and;
SOrderBy SOrderBy: string = order by;
SParam SParam: Char = 3ドルF;
SSelect SSelect: string = select;
SSelectSpaces SSelectSpaces: string = select;
SSelectStar SSelectStar: string = select *;
SSelectStarFrom SSelectStarFrom: string = select * from;
SUB_TYPE_MEMO SUB_TYPE_MEMO: Integer = 16ドル;
SWhere SWhere: string = where;
TErrorMessageSize TErrorMessageSize: Integer = 800ドル;