Scope | Visibility | Result | Name | Description |
---|
Instance | protected | TSqlConnectionSettings | GetConnectionSettings() | |
Instance | protected | TBoolean | GetCouldConnect() | |
Instance | public | | Execute(Statement: TSqlStatement) | |
Instance | public | | Flush() | |
Instance | public | TSqlResult | Query(Statement: TSqlStatement; ResultMethod: TSqlQueryResultMethod) |
Executes Statement and returns its TSqlResult if any, nil otherwise.
|
Instance | public | TSqlResult | QuerySingleRow(Statement: TSqlStatement) |
Executes Statement and returns its TSqlResult while ensuring exactly one row is in the result.
|
Instance | public | TSqlPreparedStatement | Prepare(Statement: TSqlStatement) | |
Instance | public | TSqlTransaction | StartTransaction() | |
Instance | public | | EndTransaction(Transaction: TSqlTransaction) | |
Instance | public | TInteger | ConnectionIdentifier() | |
Instance | public | TInteger | InsertId() | |
Instance | public | TInteger | NumberOfAffectedRows() | |
Instance | public | TInteger | Insert(Statement: TSqlStatement) | |
Instance | public | TBoolean | Exists(Statement: TSqlResultSetStatement) | |
Instance | public | TInteger | SelectOrInsert(Table: TObject; Columns: array of TSqlTableColumn; Row: TSqlRow) | |
Instance | public | TDecimal | SelectDecimal(Statement: TSqlResultSetStatement) | |
Instance | public | TDecimal | SelectDecimalWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TDecimal) | |
Instance | public | TInteger | SelectInteger(Statement: TSqlResultSetStatement) | |
Instance | public | TInteger | SelectIntegerWithDefault(Statement: TSqlResultSetStatement) | |
Instance | public | TInteger | SelectIntegerWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TInteger) | |
Instance | public | TText | SelectText(Statement: TSqlResultSetStatement) | |
Instance | public | TText | SelectTextWithDefault(Statement: TSqlResultSetStatement) | |
Instance | public | TText | SelectTextWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TText) | |
Instance | public | TBoolean | SelectBoolean(Statement: TSqlResultSetStatement) | |
Instance | public | TBoolean | SelectBooleanWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TBoolean) | |
Instance | public | TFloatingPoint64 | SelectFloatingPoint(Statement: TSqlResultSetStatement) | |
Instance | public | TFloatingPoint64 | SelectFloatingPointWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TFloatingPoint64) | |
Instance | public | TGregorianDate | SelectDate(Statement: TSqlResultSetStatement) | |
Instance | public | TGregorianInstant | SelectInstant(Statement: TSqlResultSetStatement) | |
Instance | public | TRgbColor | SelectColor(Statement: TSqlResultSetStatement) | |
Instance | public | TRgbColor | SelectColorWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TRgbColor) | |
Instance | public | TUuid | SelectUuid(Statement: TSqlResultSetStatement) | |
Instance | public | TUuid | SelectUuidWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TUuid) | |
Instance | public | TInputStream | SelectStream(Statement: TSqlStatement) | |
Instance | public | TBoolean | IsAlive() | |
Instance | public | TPositiveInteger32 | IdleTime() | |
Instance | public | TBoolean | UserExists(Name: TText) | |
Instance | public | TBoolean | TableExists(Name: TText) | |
Instance | public | TBoolean | TableHasConstraint(Table: TText; Constraint: TText) | |
Instance | public | TObject | CreateTableDefinition(SchemaName: TText; TableName: TText) | |
Instance | public | TObject | GetSystemInformation() | |
Instance | public | TSqlDatabase | Embellish() | |