Class TSDStoredProc (unit SDQuery)

Inherits from

TSDDataSet

TSDStoredProc

Constructors


constructor Create(AOwner: TComponent);

TSDStoredProc


Functions

procedure CopyParams(Value: TSDParams);


function DescriptionsAvailable: Boolean;

input parameter count

destructor Destroy;


procedure ExecProc;


function ParamByName(const Value: string): TSDParam;


procedure Prepare;


procedure UnPrepare;


procedure CloseCursor;


procedure Disconnect;


function GetParamsCount: Word;


function GetProcName: string;


procedure GetResultSet;


procedure OpenCursor;


procedure PrepareCursor;


procedure SetDBFlag(Flag: Integer; Value: Boolean);


procedure SetParams;


procedure SetParamsList(Value: TSDParams);


procedure SetProcName(const Value: string);


procedure CreateParamDesc;


procedure SetPrepared(Value: Boolean);


Properties

property Params : TSDParams


property StoredProcName : string


property ParamCount : Word


property Prepared : Boolean


Events

Variables

FParams : TSDParams;


FPrepared : Boolean;


FProcName : string[SQLMAXSPFULLNAMELEN+2];

Private declarations

FQueryMode : Boolean;



Constructors


constructor Create(AOwner: TComponent);

TSDStoredProc


Functions


procedure CopyParams(Value: TSDParams);


function DescriptionsAvailable: Boolean;

input parameter count


destructor Destroy;


procedure ExecProc;


function ParamByName(const Value: string): TSDParam;


procedure Prepare;


procedure UnPrepare;


procedure CloseCursor;


procedure Disconnect;


function GetParamsCount: Word;


function GetProcName: string;


procedure GetResultSet;


procedure OpenCursor;


procedure PrepareCursor;


procedure SetDBFlag(Flag: Integer; Value: Boolean);


procedure SetParams;


procedure SetParamsList(Value: TSDParams);


procedure SetProcName(const Value: string);


procedure CreateParamDesc;


procedure SetPrepared(Value: Boolean);


Properties


property Params : TSDParams


property StoredProcName : string


property ParamCount : Word


property Prepared : Boolean


Events


Variables


FParams : TSDParams;


FPrepared : Boolean;


FProcName : string[SQLMAXSPFULLNAMELEN+2];

Private declarations


FQueryMode : Boolean;