Go to the source code of this file.
Functions | |
Boolean | CompareDataFields (const TZVariantDynArray KeyValues, const TZVariantDynArray RowValues, Boolean PartialKey, Boolean CaseInsensitive) |
Compares row field values with the given ones. | |
Boolean | CompareFieldsFromResultSet (const TObjectDynArray FieldRefs, const TZVariantDynArray KeyValues, IZResultSet ResultSet, Boolean PartialKey, Boolean CaseInsensitive) |
Compares row field values with the given ones. | |
Boolean | CompareKeyFields (TField Field1, IZResultSet ResultSet, TField Field2) |
Compare values from two key fields. | |
TZSQLType | ConvertDatasetToDbcType (TFieldType Value) |
Converts TDataset Field Type to DBC Field Type. | |
TFieldType | ConvertDbcToDatasetType (TZSQLType Value) |
Converts DBC Field Type to TDataset Field Type. | |
TObjectList | ConvertFieldsToColumnInfo (TFields Fields) |
Converts field definitions into column information objects. | |
CopyDataFieldsToVars (const TObjectDynArray Fields, IZResultSet ResultSet, IZVariablesList Variables) | |
Copy a set of specified field values to variables. | |
TIntegerDynArray | CreateFieldsLookupTable (TFields Fields) |
Creates a fields lookup table to define fixed position of the field in dataset. | |
DateTimeToNative (TFieldType DataType, TDateTime Data, Pointer Buffer) | |
Converts datetime value into TDataset internal presentation. | |
Integer | DefineFieldIndex (const TIntegerDynArray FieldsLookupTable, TField Field) |
Defines an original field index in the dataset. | |
TIntegerDynArray | DefineFieldIndices (const TIntegerDynArray FieldsLookupTable, const TObjectDynArray FieldRefs) |
Defines an original field indices in the dataset. | |
TObjectDynArray | DefineFields (TDataset DataSet, const string FieldNames, Boolean &OnlyDataFields) |
Defines fields indices for the specified dataset. | |
TObjectDynArray | DefineFilterFields (TDataset DataSet, IZExpression Expression) |
Defins a indices of filter fields. | |
string | DefineKeyFields (TFields Fields) |
Defines a list of key field names. | |
DefineSortedFields (TDataset DataSet, const string SortedFields, TObjectDynArray &FieldRefs, TBooleanDynArray &FieldDirs, Boolean &OnlyDataFields) | |
Defins a indices and directions for sorted fields. | |
FetchFromResultSet (IZResultSet ResultSet, const TIntegerDynArray FieldsLookupTable, TFields Fields, TZRowAccessor RowAccessor) | |
Fetches columns from specified resultset. | |
TDateTime | NativeToDateTime (TFieldType DataType, Pointer Buffer) |
Converts date times from TDataset internal presentation into datetime value. | |
PostToResultSet (IZResultSet ResultSet, const TIntegerDynArray FieldsLookupTable, TFields Fields, TZRowAccessor RowAccessor) | |
Posts columns from specified resultset. | |
PrepareValuesForComparison (const TObjectDynArray FieldRefs, TZVariantDynArray &DecodedKeyValues, IZResultSet ResultSet, Boolean PartialKey, Boolean CaseInsensitive) | |
Prepares values for comparison by CompareFieldsFromResultSet. | |
RetrieveDataFieldsFromResultSet (const TObjectDynArray FieldRefs, IZResultSet ResultSet, TZVariantDynArray &ResultValues) | |
Retrieves a set of specified field values. | |
RetrieveDataFieldsFromRowAccessor (const TObjectDynArray FieldRefs, const TIntegerDynArray FieldIndices, TZRowAccessor RowAccessor, TZVariantDynArray &ResultValues) | |
Retrieves a set of specified field values. | |
SplitQualifiedObjectName (string QualifiedName, string &Catalog, string &Schema, string &ObjectName) | |
Splits up a qualified object name into pieces. | |
Variables | |
const IZTokenizer | CommonTokenizer |
Common variables. |
Boolean CompareDataFields | ( | const TZVariantDynArray | KeyValues, | |
const TZVariantDynArray | RowValues, | |||
Boolean | PartialKey, | |||
Boolean | CaseInsensitive | |||
) |
Compares row field values with the given ones.
KeyValues | given values. | |
RowValues | row field values. | |
PartialKey | True if values should be started with the keys. | |
CaseInsensitive | True if keys are case insensitive. |
if values are equal.
Definition at line 946 of file ZDatasetUtils.pas.
Boolean CompareFieldsFromResultSet | ( | const TObjectDynArray | FieldRefs, | |
const TZVariantDynArray | KeyValues, | |||
IZResultSet | ResultSet, | |||
Boolean | PartialKey, | |||
Boolean | CaseInsensitive | |||
) |
Compares row field values with the given ones.
FieldRefs | an array with interested field object references. | |
KeyValues | given values. | |
RowValues | row field values. | |
PartialKey | True if values should be started with the keys. | |
CaseInsensitive | True if keys are case insensitive. |
if values are equal.
FieldRefs | an array with interested field object references. | |
KeyValues | given values. | |
ResultSet | a resultset to get field values. | |
PartialKey |
| |
CaseInsensitive |
|
if values are equal.
Definition at line 1093 of file ZDatasetUtils.pas.
Referenced by RetrieveDataFieldsFromRowAccessor().
Boolean CompareKeyFields | ( | TField | Field1, | |
IZResultSet | ResultSet, | |||
TField | Field2 | |||
) |
Compare values from two key fields.
Field1 | the first field object. | |
ResultSet | the resultset to read the first field value. | |
Field2 | the second field object. |
TZSQLType ConvertDatasetToDbcType | ( | TFieldType | Value | ) |
Converts TDataset Field Type to DBC Field Type.
Value | an initial TDataset field type. |
!!I do not know if it is a stUnicodeString or stUnicodeStream
Definition at line 422 of file ZDatasetUtils.pas.
TFieldType ConvertDbcToDatasetType | ( | TZSQLType | Value | ) |
Converts DBC Field Type to TDataset Field Type.
Value | an initial DBC field type. |
Definition at line 378 of file ZDatasetUtils.pas.
TObjectList ConvertFieldsToColumnInfo | ( | TFields | Fields | ) |
Converts field definitions into column information objects.
Fields | a collection of field definitions. |
Definition at line 468 of file ZDatasetUtils.pas.
CopyDataFieldsToVars | ( | const TObjectDynArray | Fields, | |
IZResultSet | ResultSet, | |||
IZVariablesList | Variables | |||
) |
Copy a set of specified field values to variables.
Fields | an array with interested field object references. | |
ResultSet | an initial result set object. | |
Variables | a list of variables. |
Definition at line 888 of file ZDatasetUtils.pas.
TIntegerDynArray CreateFieldsLookupTable | ( | TFields | Fields | ) |
Creates a fields lookup table to define fixed position of the field in dataset.
Fields | a collection of TDataset fields in initial order. |
DateTimeToNative | ( | TFieldType | DataType, | |
TDateTime | Data, | |||
Pointer | Buffer | |||
) |
Converts datetime value into TDataset internal presentation.
DataType | a type of date-time field. | |
Data | a data which contains a value. | |
Buffer | a field buffer pointer |
Definition at line 1224 of file ZDatasetUtils.pas.
Integer DefineFieldIndex | ( | const TIntegerDynArray | FieldsLookupTable, | |
TField | Field | |||
) |
Defines an original field index in the dataset.
FieldsLookupTable | a lookup table to define original index. | |
Field | a TDataset field object. |
TIntegerDynArray DefineFieldIndices | ( | const TIntegerDynArray | FieldsLookupTable, | |
const TObjectDynArray | FieldRefs | |||
) |
Defines an original field indices in the dataset.
FieldsLookupTable | a lookup table to define original index. | |
FieldRefs | a TDataset field object references. |
TObjectDynArray DefineFields | ( | TDataset | DataSet, | |
const string | FieldNames, | |||
Boolean & | OnlyDataFields | |||
) |
Defines fields indices for the specified dataset.
DataSet | a dataset object. | |
FieldNames | a list of field names. | |
OnlyDataFields | True if only data fields selected. |
Definition at line 674 of file ZDatasetUtils.pas.
TObjectDynArray DefineFilterFields | ( | TDataset | DataSet, | |
IZExpression | Expression | |||
) |
Defins a indices of filter fields.
Dataset | a dataset object. | |
Expression | a expression calculator. |
Definition at line 736 of file ZDatasetUtils.pas.
string DefineKeyFields | ( | TFields | Fields | ) |
Defines a list of key field names.
Fields | a collection of dataset fields. |
Definition at line 1192 of file ZDatasetUtils.pas.
DefineSortedFields | ( | TDataset | DataSet, | |
const string | SortedFields, | |||
TObjectDynArray & | FieldRefs, | |||
TBooleanDynArray & | FieldDirs, | |||
Boolean & | OnlyDataFields | |||
) |
Defins a indices and directions for sorted fields.
Dataset | a dataset object. | |
SortedFields | an encoded fields for sorting in the format <Field name>=""> [ASC | DESC] [, ...] | |
FieldRefs | a decoded field object references. | |
FieldDirs | a decoded field directions. | |
OnlyDataFields | True if only data fields selected. |
FetchFromResultSet | ( | IZResultSet | ResultSet, | |
const TIntegerDynArray | FieldsLookupTable, | |||
TFields | Fields, | |||
TZRowAccessor | RowAccessor | |||
) |
Fetches columns from specified resultset.
ResultSet | a source resultset. | |
FieldsLookupTable | a lookup table to define original index. | |
Fields | a collection of field definitions. | |
RowAccessor | a destination row accessor. |
Definition at line 508 of file ZDatasetUtils.pas.
TDateTime NativeToDateTime | ( | TFieldType | DataType, | |
Pointer | Buffer | |||
) |
Converts date times from TDataset internal presentation into datetime value.
DataType | a type of date-time field. | |
Buffer | a field buffer pointer |
Compare values from two key fields.
Field1 | the first field object. | |
ResultSet | the resultset to read the first field value. | |
Field2 | the second field object. |
Dataset | a dataset object. | |
SortedFields | an encoded fields for sorting in the format <Field name>=""> [ASC | DESC] [, ...] | |
FieldRefs | a decoded field object references. | |
FieldDirs | a decoded field directions. | |
OnlyDataFields | True if only data fields selected. |
Fields | a collection of TDataset fields in initial order. |
FieldsLookupTable | a lookup table to define original index. | |
Field | a TDataset field object. |
FieldsLookupTable | a lookup table to define original index. | |
FieldRefs | a TDataset field object references. |
Definition at line 1255 of file ZDatasetUtils.pas.
PostToResultSet | ( | IZResultSet | ResultSet, | |
const TIntegerDynArray | FieldsLookupTable, | |||
TFields | Fields, | |||
TZRowAccessor | RowAccessor | |||
) |
Posts columns from specified resultset.
ResultSet | a source resultset. | |
FieldsLookupTable | a lookup table to define original index. | |
Fields | a collection of field definitions. | |
RowAccessor | a destination row accessor. |
Definition at line 580 of file ZDatasetUtils.pas.
PrepareValuesForComparison | ( | const TObjectDynArray | FieldRefs, | |
TZVariantDynArray & | DecodedKeyValues, | |||
IZResultSet | ResultSet, | |||
Boolean | PartialKey, | |||
Boolean | CaseInsensitive | |||
) |
Prepares values for comparison by CompareFieldsFromResultSet.
FieldRefs | an array with interested field object references. | |
DecodedKeyValues | given values. | |
ResultSet | a resultset to get field values. | |
PartialKey | True if values should be started with the keys. | |
CaseInsensitive | True if keys are case insensitive. |
Definition at line 990 of file ZDatasetUtils.pas.
RetrieveDataFieldsFromResultSet | ( | const TObjectDynArray | FieldRefs, | |
IZResultSet | ResultSet, | |||
TZVariantDynArray & | ResultValues | |||
) |
Retrieves a set of specified field values.
FieldRefs | an array with interested field object references. | |
ResultSet | an initial result set object. | |
ResultValues | a container for result values. |
Definition at line 768 of file ZDatasetUtils.pas.
RetrieveDataFieldsFromRowAccessor | ( | const TObjectDynArray | FieldRefs, | |
const TIntegerDynArray | FieldIndices, | |||
TZRowAccessor | RowAccessor, | |||
TZVariantDynArray & | ResultValues | |||
) |
Retrieves a set of specified field values.
FieldRefs | an array with interested field object references. | |
FieldIndices | an array with interested field indices. | |
RowAccessor | a row accessor object. | |
ResultValues | a container for result values. |
Definition at line 827 of file ZDatasetUtils.pas.
References CompareFieldsFromResultSet().
SplitQualifiedObjectName | ( | string | QualifiedName, | |
string & | Catalog, | |||
string & | Schema, | |||
string & | ObjectName | |||
) |
Splits up a qualified object name into pieces.
Catalog, schema and objectname.
const IZTokenizer CommonTokenizer |