Data.SqlExpr

• Up to Parent: Data

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.

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.
TFieldList	TFieldList is an alias for the System.Classes.TList class.
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.
TSQLQuery	TSQLQuery represents a query that is executed using dbExpress.
TSQLSchemaInfo	Record that indicates whether the dataset represents metadata from the server, and, if so, what kind.
TSqlServerMethod	TDataSet used to call DataSnap server methods.
TSQLStoredProc	TSQLStoredProc represents a stored procedure that is executed using dbExpress.
TSQLTable	TSQLTable represents a database table that is accessed using dbExpress.
TTransactionDesc	Transaction description record.
TTransactionItem	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.
TConnectionState	TConnectionState describes the state of a TSQLConnection component.
TConnectionUserType	Enumeration for user type connections.
TFieldDescList	Array of TFLDDesc.
TFieldList	TFieldList is an alias for the System.Classes.TList class.
TGetDriverFunc	C++ implementation for getting the driver's functions.
TLocale	TLocale is an alias for the Pointer type.
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	BlobTypeMap: array[22..36] of TFieldType;
DataTypeMap	DataTypeMap: array[0..38] of TFieldType;
FldSubTypeMap	FldSubTypeMap: array[0..51] of Word;
FldTypeMap	FldTypeMap: TFieldMap;
TFieldDescList	Array of TFLDDesc.

Constants

BlobTypeMap	BlobTypeMap: array[22..36] of TFieldType;
csStateClosed	csStateClosed: TConnectionState = csStateClosed;
csStateConnecting	csStateConnecting: TConnectionState = csStateConnecting;
csStateDisconnecting	csStateDisconnecting: TConnectionState = csStateDisconnecting;
csStateExecuting	csStateExecuting: TConnectionState = csStateExecuting;
csStateFetching	csStateFetching: TConnectionState = csStateFetching;
csStateOpen	csStateOpen: TConnectionState = csStateOpen;
DataTypeMap	DataTypeMap: array[0..38] of TFieldType;
DefaultCursor	DefaultCursor: Integer = 0;
DefaultMaxBlobSize	DefaultMaxBlobSize: Integer = $FFFFFFFF;
DefaultRowsetSize	DefaultRowsetSize: Integer = $14;
eConnect	eConnect: EConnectFlag = eConnect;
eDisconnect	eDisconnect: EConnectFlag = eDisconnect;
eReconnect	eReconnect: EConnectFlag = eReconnect;
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;
eUserDataSet	eUserDataSet: TConnectionUserType = eUserDataSet;
eUserMonitor	eUserMonitor: TConnectionUserType = eUserMonitor;
exceptCommand	exceptCommand: TSQLExceptionType = exceptCommand;
exceptConnection	exceptConnection: TSQLExceptionType = exceptConnection;
exceptCursor	exceptCursor: TSQLExceptionType = exceptCursor;
exceptMetaData	exceptMetaData: TSQLExceptionType = exceptMetaData;
exceptUseLast	exceptUseLast: TSQLExceptionType = exceptUseLast;
FldSubTypeMap	FldSubTypeMap: array[0..51] of Word;
FldTypeMap	FldTypeMap: TFieldMap;
HourGlassCursor	HourGlassCursor: Integer = $FFFFFFF5;
SAnd	SAnd: string = and;
SOrderBy	SOrderBy: string = order by;
SParam	SParam: Char = $3F;
SSelect	SSelect: string = select;
SSelectSpaces	SSelectSpaces: string = select;
SSelectStar	SSelectStar: string = select *;
SSelectStarFrom	SSelectStarFrom: string = select * from;
stColumns	stColumns: TSchemaType = stColumns;
stIndexes	stIndexes: TSchemaType = stIndexes;
stNoSchema	stNoSchema: TSchemaType = stNoSchema;
stPackages	stPackages: TSchemaType = stPackages;
stProcedureParams	stProcedureParams: TSchemaType = stProcedureParams;
stProcedures	stProcedures: TSchemaType = stProcedures;
stSysTables	stSysTables: TSchemaType = stSysTables;
stTables	stTables: TSchemaType = stTables;
stUserNames	stUserNames: TSchemaType = stUserNames;
SUB_TYPE_MEMO	SUB_TYPE_MEMO: Integer = $16;
SWhere	SWhere: string = where;
TErrorMessageSize	TErrorMessageSize: Integer = $800;
tsSynonym	tsSynonym: TTableScope = tsSynonym;
tsSysTable	tsSysTable: TTableScope = tsSysTable;
tsTable	tsTable: TTableScope = tsTable;
tsView	tsView: TTableScope = tsView;
xilCUSTOM	xilCUSTOM: TTransIsolationLevel = xilCUSTOM;
xilDIRTYREAD	xilDIRTYREAD: TTransIsolationLevel = xilDIRTYREAD;
xilREADCOMMITTED	xilREADCOMMITTED: TTransIsolationLevel = xilREADCOMMITTED;
xilREPEATABLEREAD	xilREPEATABLEREAD: TTransIsolationLevel = xilREPEATABLEREAD;