Database connection that exposes a SQL based interface to the appropriate database. These cannot be created directly - you must use a TDBConnPool.GetConnection call to get a connection. The connection must always be returned using TDBConnPool.YieldConnection otherwise the connection will leak.


Properties

ColType[ACol : Integer] : TKDBColumnType
ColNull[ACol : Integer] : Boolean
ColString[ACol : Integer] : String
ColInteger[ACol : Integer] : Integer
ColInt64[ACol : Integer] : Int64
ColDouble[ACol : Integer] : Double
ColMemory[ACol : Integer] : TMemoryStream
ColTimestamp[ACol : Integer] : TTimeStamp
ColDateAndTime[ACol : Integer] : IDateAndTime
ColTypeByName[AName : String] : TKDBColumnType
ColNullByName[AName : String] : Boolean
ColStringByName[AName : String] : String
ColIntegerByName[AName : String] : Integer
ColInt64ByName[AName : String] : Int64
ColDoubleByName[AName : String] : Double
ColMemoryByName[AName : String] : TMemoryStream
ColTimeStampByName[AName : String] : TTimeStamp
ColDateAndTimeByName[AName : String] : IDateAndTime
ColCount : Integer
RowsAffected : Integer
SQL : String

Methods

BindBlobFromBytes(AParamName : String, AParamValue : TBytes)
BindBlobFromString(AParamName : String, AParamValue : String)
BindDateAndTime(AParamName : String, AParamValue : IDateAndTime)
BindDouble(AParamName : String, AParamValue : Double)
BindInt64(AParamName : String, AParamValue : Int64)
BindInteger(AParamName : String, AParamValue : Integer)
BindIntegerFromBoolean(AParamName : String, AParamValue : Boolean)
BindNull(AParamName : String)
BindString(AParamName : String, AParamValue : String)
BindTimeStamp(AParamName : String, AParamValue : TTimeStamp)
ClearDatabase
ColByName(AColName : String) : Integer
ColName(ACol : Integer) : String
Commit
CountSQL(ASql : String) : Cardinal
DatabaseSize : Int64
DropColumn(ATableName : String, AColumnName : String)
DropTable(ATableName : String)
ExecSQL(ASql : String) : Integer
Execute
ExistsByKey(sTableName : String, sKeyField : String, ikey : Integer) : Boolean
FetchNext : Boolean
Lookup(ATableName : String, AKeyField : String, AKeyValue : String, AValueField : String, ADefault : String) : String
LookupString(ATableName : String, AKeyField : String, AKeyValue : String, AValueField : String, ADefault : String) : String
Prepare
RenameColumn(ATableName : String, AOldColumnName : String, ANewColumnName : String, AColumnDetails : String)
RenameTable(AOldTableName : String, ANewTableName : String)
Rollback
StartTransact
SupportsSizing : Boolean
TableSize(sName : String) : Int64
Terminate

© Kestral Computing P/L 2000 - 2003. HL7Connect v2.00-063 generated on 30-Nov 2015.
Keywords: IKDBConnection, TKDBConnection