TSqlResult
Iterator for an SQL result set.
Inheritance
| Level | Ancestor | Description |
|---|---|---|
| 1 | TObject | Ultimate ancestor in a class hierarchy |
| 2 | TSqlResult |
Source
Sql.Result.pas (48)
Description
FetchRow fetches the next row from the result and returns False when no more row is present. The iterator is initialized before the first row
so FetchRow should be called for the first row as well. Use the Read...() functions to fetch individual column values in the order in which
they appear in the originating SQL query. No type conversions are applied during calls to the Read...() functions so reading a value of the wrong type will raise
an exception. Also, reading beyond the last column and the last row will raise an exception.
Methods
| Scope | Visibility | Result | Name | Description |
|---|---|---|---|---|
| Instance | public | TInteger32 | GetRowCount() | |
| Instance | public | TRecordType | GetType() | |
| Instance | public | TBoolean | FetchRow() | |
| Instance | public | TBoolean | ReadNull() |
Returns True when the current column value is NULL and moves the iterator position to the next value. If False is returned,
the iterator position is kept at the current column value so it can be read using one of the other Read...() functions.
|
| Instance | public | TText | ReadText() | |
| Instance | public | TInteger | ReadInteger() | |
| Instance | public | TDecimal | ReadDecimal() | |
| Instance | public | TFloatingPoint64 | ReadFloatingPoint() | |
| Instance | public | TBoolean | ReadBoolean() | |
| Instance | public | T2dFloatingPoint64Point | ReadFloatingPoint64Point() | |
| Instance | public | TFloatingPoint64Interval | ReadFloatingPoint64Interval() | |
| Instance | public | TRgbColor | ReadColor() | |
| Instance | public | TUri | ReadUri() | |
| Instance | public | TUuid | ReadUuid() | |
| Instance | public | TMemoryBlock | ReadByteBlock() | |
| Instance | public | TNamedFile | ReadNamedFile() | |
| Instance | public | TXmlValue | ReadXmlValue() | |
| Instance | public | T2dGeometry | Read2dGeometry() | |
| Instance | public | TRecordSet | ReadRecordSet() | |
| Instance | public | TType | ReadType() | |
| Instance | public | TDateTime | ReadDateTime() | |
| Instance | public | TGregorianDate | ReadDate() | |
| Instance | public | TGregorianTime | ReadTime() | |
| Instance | public | TGregorianInstant | ReadInstant() | |
| Instance | public | TValue | ReadValue() | |
| Instance | public | TValue | Old_ReadValue(Type_: TType) |