TSQLConnection

type TSQLConnection = class(TDatabase)

protected

  FConnOptions: TConnOptions;

  FSQLFormatSettings: TFormatSettings;

  procedure AddFieldToUpdateWherePart(); virtual;

  function ConstructInsertSQL(); virtual;

  function ConstructUpdateSQL(); virtual;

  function ConstructDeleteSQL(); virtual;

  function ConstructRefreshSQL(); virtual;

  function CreateCustomQuery(); virtual;

  function InitialiseUpdateStatement();

  procedure ApplyFieldUpdate(); virtual;

  procedure ApplyRecUpdate(); virtual;

  function RefreshLastInsertID(); virtual;

  procedure GetDBInfo();

  function PortParamName; virtual;

  function GetConnectionCharSet; virtual;

  procedure SetTransaction(); virtual;

  procedure DoConnect; override;

  procedure DoInternalConnect; override;

  procedure DoInternalDisconnect; override;

  function GetAsString();

  function GetAsSQLText();

  function GetHandle; virtual;

  function LogEvent();

  procedure LogParams(); virtual;

  procedure Log(); virtual;

  procedure RegisterStatement();

  procedure UnRegisterStatement();

  procedure UnPrepareStatements();

  function AllocateCursorHandle; virtual; abstract;

  procedure DeAllocateCursorHandle(); virtual; abstract;

  function StrToStatementType(); virtual;

  procedure PrepareStatement(); virtual; abstract;

  procedure UnPrepareStatement(); virtual; abstract;

  procedure Execute(); virtual; abstract;

  function RowsAffected(); virtual;

  function Fetch(); virtual; abstract;

  procedure AddFieldDefs(); virtual; abstract;

  function AddFieldDef();

  function LoadField(); virtual; abstract;

  procedure LoadBlobIntoBuffer(); virtual; abstract;

  procedure FreeFldBuffers(); virtual;

  function AllocateTransactionHandle; virtual; abstract;

  function GetTransactionHandle(); virtual; abstract;

  function Commit(); virtual; abstract;

  function RollBack(); virtual; abstract;

  function StartImplicitTransaction(); virtual;

  function StartDBTransaction(); virtual; abstract;

  procedure CommitRetaining(); virtual; abstract;

  procedure RollBackRetaining(); virtual; abstract;

  procedure UpdateIndexDefs(); virtual;

  function GetSchemaInfoSQL(); virtual;

  function GetNextValueSQL(); virtual;

  procedure MaybeConnect;

  property Statements: TThreadList; [r]

  property Port: Cardinal; [rw]

  property CodePage: TSystemCodePage; [r]

public

  constructor Create(); override;

  destructor Destroy; override;

  procedure StartTransaction; override;

  procedure EndTransaction; override;

  procedure ExecuteDirect();

  function GetObjectNames(); virtual;

  function HasTable();

  procedure GetTableNames(); virtual;

  procedure GetProcedureNames(); virtual;

  procedure GetFieldNames(); virtual;

  procedure GetSchemaNames(); virtual;

  procedure GetSequenceNames(); virtual;

  function GetConnectionInfo(); virtual;

  function GetStatementInfo(); virtual;

  procedure CreateDB; virtual;

  procedure DropDB; virtual;

  function GetNextValue(); virtual;

  property ConnOptions: TConnOptions; [r]

  property Handle: Pointer; [r]

  property FieldNameQuoteChars: TQuoteChars; [rw]

published

  property Password: string; [rw]

  property Transaction: TSQLTransaction; [rw]

  property UserName: string; [rw]

  property CharSet: string; [rw]

  property HostName: string; [rw]

  property OnLog: TDBLogNotifyEvent; [rw]

  property LogEvents: TDBEventTypes; [rw]

  property Options: TSQLConnectionOptions; [rw]

  property Role: string; [rw]

  property Connected: Boolean;

  property DatabaseName: string;

  property KeepConnection: Boolean;

  property LoginPrompt: Boolean;

  property Params: TStrings;

  property OnLogin: TLoginEvent;

end;

TSQLConnection

TDatabase

TCustomConnection

TObject