Public Member Functions | |
string | GetCatalogName (Integer Column) |
Gets the designated column's table's catalog name. | |
Integer | GetColumnCount () |
Returns the number of columns in this ResultSet object. | |
Integer | GetColumnDisplaySize (Integer Column) |
Indicates the designated column's normal maximum width in characters. | |
string | GetColumnLabel (Integer Column) |
Gets the designated column's suggested title for use in printouts and displays. | |
string | GetColumnName (Integer Column) |
Get the designated column's name. | |
TZSQLType | GetColumnType (Integer Column) |
Retrieves the designated column's SQL type. | |
string | GetColumnTypeName (Integer Column) |
Retrieves the designated column's database-specific type name. | |
string | GetDefaultValue (Integer Column) |
Gets a default value for this field. | |
Integer | GetPrecision (Integer Column) |
Get the designated column's number of decimal digits. | |
Integer | GetScale (Integer Column) |
Gets the designated column's number of digits to right of the decimal point. | |
string | GetSchemaName (Integer Column) |
Get the designated column's table's schema. | |
string | GetTableName (Integer Column) |
Gets the designated column's table name. | |
Boolean | HasDefaultValue (Integer Column) |
Finds whether this field has a default value. | |
Boolean | IsAutoIncrement (Integer Column) |
Indicates whether the designated column is automatically numbered, thus read-only. | |
Boolean | IsCaseSensitive (Integer Column) |
Indicates whether a column's case matters. | |
Boolean | IsCurrency (Integer Column) |
Indicates whether the designated column is a cash value. | |
Boolean | IsDefinitelyWritable (Integer Column) |
Indicates whether a write on the designated column will definitely succeed. | |
TZColumnNullableType | IsNullable (Integer Column) |
Indicates the nullability of values in the designated column. | |
Boolean | IsReadOnly (Integer Column) |
Indicates whether the designated column is definitely not writable. | |
Boolean | IsSearchable (Integer Column) |
Indicates whether the designated column can be used in a where clause. | |
Boolean | IsSigned (Integer Column) |
Indicates whether values in the designated column are signed numbers. | |
Boolean | IsWritable (Integer Column) |
Indicates whether it is possible for a write on the designated column to succeed. | |
Protected Member Functions | |
ClearColumn (TZColumnInfo ColumnInfo) | |
Clears specified column information. | |
IZResultSet | GetTableColumns (TZTableRef TableRef) |
Gets a table description result set. | |
LoadColumn (Integer ColumnIndex, TZColumnInfo ColumnInfo, IZSelectSchema SelectSchema) | |
Initializes on single column of the result set. | |
LoadColumns () | |
Initializes columns with additional data. | |
Boolean | ReadColumnByName (string FieldName, TZTableRef TableRef, TZColumnInfo ColumnInfo) |
Reads a column information from table metadata. | |
Boolean | ReadColumnByRef (TZFieldRef FieldRef, TZColumnInfo ColumnInfo) |
Reads a column information from table metadata. | |
ReplaceStarColumns (IZSelectSchema SelectSchema) | |
Replaces '*' columns in the select schema. | |
Protected Attributes | |
TStrings | ColumnsLabels |
IZIdentifierConvertor | IdentifierConvertor |
Boolean | Loaded |
IZDatabaseMetadata | MetaData |
TZAbstractResultSet | ResultSet |
string | SQL |
Definition at line 68 of file ZDbcMySqlResultSet.pas.
TZAbstractResultSetMetadata::ClearColumn | ( | TZColumnInfo | ColumnInfo | ) | [protected, inherited] |
Clears specified column information.
ColumnInfo | a column information object. |
Definition at line 840 of file ZDbcResultSetMetadata.pas.
string TZAbstractResultSetMetadata::GetCatalogName | ( | Integer | Column | ) | [inherited] |
Gets the designated column's table's catalog name.
column | the first column is 1, the second is 2, ... |
Definition at line 694 of file ZDbcResultSetMetadata.pas.
Integer TZAbstractResultSetMetadata::GetColumnCount | ( | ) | [inherited] |
Returns the number of columns in this ResultSet
object.
Definition at line 464 of file ZDbcResultSetMetadata.pas.
Integer TZAbstractResultSetMetadata::GetColumnDisplaySize | ( | Integer | Column | ) | [inherited] |
Indicates the designated column's normal maximum width in characters.
column | the first column is 1, the second is 2, ... |
Definition at line 567 of file ZDbcResultSetMetadata.pas.
string TZAbstractResultSetMetadata::GetColumnLabel | ( | Integer | Column | ) | [inherited] |
Gets the designated column's suggested title for use in printouts and displays.
column | the first column is 1, the second is 2, ... |
Definition at line 582 of file ZDbcResultSetMetadata.pas.
string TZAbstractResultSetMetadata::GetColumnName | ( | Integer | Column | ) | [inherited] |
Get the designated column's name.
column | the first column is 1, the second is 2, ... |
Definition at line 621 of file ZDbcResultSetMetadata.pas.
TZSQLType TZMySQLResultSetMetadata::GetColumnType | ( | Integer | Column | ) |
Retrieves the designated column's SQL type.
column | the first column is 1, the second is 2, ... |
Reimplemented from TZAbstractResultSetMetadata.
Definition at line 269 of file ZDbcMySqlResultSet.pas.
string TZAbstractResultSetMetadata::GetColumnTypeName | ( | Integer | Column | ) | [inherited] |
Retrieves the designated column's database-specific type name.
column | the first column is 1, the second is 2, ... |
Definition at line 725 of file ZDbcResultSetMetadata.pas.
string TZAbstractResultSetMetadata::GetDefaultValue | ( | Integer | Column | ) | [inherited] |
Gets a default value for this field.
column | the first column is 1, the second is 2, ... |
Definition at line 784 of file ZDbcResultSetMetadata.pas.
Integer TZAbstractResultSetMetadata::GetPrecision | ( | Integer | Column | ) | [inherited] |
Get the designated column's number of decimal digits.
column | the first column is 1, the second is 2, ... |
Definition at line 651 of file ZDbcResultSetMetadata.pas.
Integer TZAbstractResultSetMetadata::GetScale | ( | Integer | Column | ) | [inherited] |
Gets the designated column's number of digits to right of the decimal point.
column | the first column is 1, the second is 2, ... |
Definition at line 665 of file ZDbcResultSetMetadata.pas.
string TZAbstractResultSetMetadata::GetSchemaName | ( | Integer | Column | ) | [inherited] |
Get the designated column's table's schema.
column | the first column is 1, the second is 2, ... |
Definition at line 636 of file ZDbcResultSetMetadata.pas.
IZResultSet TZAbstractResultSetMetadata::GetTableColumns | ( | TZTableRef | TableRef | ) | [protected, inherited] |
Gets a table description result set.
TableRef | a table reference object. |
Definition at line 815 of file ZDbcResultSetMetadata.pas.
string TZAbstractResultSetMetadata::GetTableName | ( | Integer | Column | ) | [inherited] |
Gets the designated column's table name.
column | the first column is 1, the second is 2, ... |
Definition at line 679 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::HasDefaultValue | ( | Integer | Column | ) | [inherited] |
Finds whether this field has a default value.
column | the first column is 1, the second is 2, ... |
Definition at line 799 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::IsAutoIncrement | ( | Integer | Column | ) | [inherited] |
Indicates whether the designated column is automatically numbered, thus read-only.
column | the first column is 1, the second is 2, ... |
true
if so; false
otherwise Definition at line 477 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::IsCaseSensitive | ( | Integer | Column | ) | [inherited] |
Indicates whether a column's case matters.
column | the first column is 1, the second is 2, ... |
true
if so; false
otherwise Definition at line 492 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::IsCurrency | ( | Integer | Column | ) | [inherited] |
Indicates whether the designated column is a cash value.
column | the first column is 1, the second is 2, ... |
true
if so; false
otherwise Definition at line 522 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::IsDefinitelyWritable | ( | Integer | Column | ) | [inherited] |
Indicates whether a write on the designated column will definitely succeed.
column | the first column is 1, the second is 2, ... |
true
if so; false
otherwise Definition at line 769 of file ZDbcResultSetMetadata.pas.
TZColumnNullableType TZMySQLResultSetMetadata::IsNullable | ( | Integer | Column | ) |
Indicates the nullability of values in the designated column.
column | the first column is 1, the second is 2, ... |
columnNoNulls
, columnNullable
or columnNullableUnknown
Reimplemented from TZAbstractResultSetMetadata.
Definition at line 286 of file ZDbcMySqlResultSet.pas.
Boolean TZAbstractResultSetMetadata::IsReadOnly | ( | Integer | Column | ) | [inherited] |
Indicates whether the designated column is definitely not writable.
column | the first column is 1, the second is 2, ... |
true
if so; false
otherwise Definition at line 739 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::IsSearchable | ( | Integer | Column | ) | [inherited] |
Indicates whether the designated column can be used in a where clause.
column | the first column is 1, the second is 2, ... |
true
if so; false
otherwise Definition at line 507 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::IsSigned | ( | Integer | Column | ) | [inherited] |
Indicates whether values in the designated column are signed numbers.
column | the first column is 1, the second is 2, ... |
true
if so; false
otherwise Definition at line 552 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::IsWritable | ( | Integer | Column | ) | [inherited] |
Indicates whether it is possible for a write on the designated column to succeed.
column | the first column is 1, the second is 2, ... |
true
if so; false
otherwise Definition at line 754 of file ZDbcResultSetMetadata.pas.
TZAbstractResultSetMetadata::LoadColumn | ( | Integer | ColumnIndex, | |
TZColumnInfo | ColumnInfo, | |||
IZSelectSchema | SelectSchema | |||
) | [protected, inherited] |
Initializes on single column of the result set.
ColumnIndex | a column index in the query. | |
ColumnInfo | a column information object to be initialized. | |
SelectSchema | a schema of the select statement. |
Definition at line 956 of file ZDbcResultSetMetadata.pas.
TZAbstractResultSetMetadata::LoadColumns | ( | ) | [protected, inherited] |
Initializes columns with additional data.
Definition at line 1036 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::ReadColumnByName | ( | string | FieldName, | |
TZTableRef | TableRef, | |||
TZColumnInfo | ColumnInfo | |||
) | [protected, inherited] |
Reads a column information from table metadata.
FieldName | a name of the field. | |
TableRef | a table reference object. | |
ColumnInfo | a column information object. |
True
is column was found and read. Definition at line 862 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::ReadColumnByRef | ( | TZFieldRef | FieldRef, | |
TZColumnInfo | ColumnInfo | |||
) | [protected, inherited] |
Reads a column information from table metadata.
FieldRef | a field reference object. | |
ColumnInfo | a column information object. |
True
if column was found and read. Definition at line 932 of file ZDbcResultSetMetadata.pas.
TZAbstractResultSetMetadata::ReplaceStarColumns | ( | IZSelectSchema | SelectSchema | ) | [protected, inherited] |
Replaces '*' columns in the select schema.
SelectSchema | a query select schema. |
Definition at line 998 of file ZDbcResultSetMetadata.pas.
TStrings TZAbstractResultSetMetadata::ColumnsLabels [protected, inherited] |
FColumnsLabels For writing
Definition at line 249 of file ZDbcResultSetMetadata.pas.
IZIdentifierConvertor TZAbstractResultSetMetadata::IdentifierConvertor [protected, inherited] |
FIdentifierConvertor For writing
Definition at line 256 of file ZDbcResultSetMetadata.pas.
Boolean TZAbstractResultSetMetadata::Loaded [protected, inherited] |
Definition at line 259 of file ZDbcResultSetMetadata.pas.
IZDatabaseMetadata TZAbstractResultSetMetadata::MetaData [protected, inherited] |
Definition at line 246 of file ZDbcResultSetMetadata.pas.
TZAbstractResultSet TZAbstractResultSetMetadata::ResultSet [protected, inherited] |
FResultSet For writing
Definition at line 262 of file ZDbcResultSetMetadata.pas.
string TZAbstractResultSetMetadata::SQL [protected, inherited] |
Definition at line 252 of file ZDbcResultSetMetadata.pas.