EPUB | CHM | PDF

TMySQLStoredProc.Methods.ExecProc

Top Previous Next

Executes stored routine without storing resultset.

Syntax:

procedure ExecProc;

Description:

ExecProc method is used to execute stored routine without storing a resultset. This can be useful when routine does not return a resultset, or when a resultset from the routine is not required for further processing. ExecProc just executes CALL procedure_name(params) or SELECT function_name(params) statement filled with the parameters from Params property.

note If you need to store resultset from routine please use Open method or set Active property to True.

See also: TMySQLStoredProc.Params, TMySQLDataSet.Open, TMySQLDataSet.Active