Returns list of stored procedures available at the moment in the current database.
This procedure is deprecated. Please use GetRoutinesNames instead.
Syntax:
GetStoredProcNames(Pattern: string; List: TStrings);
Parameters:
Pattern
Use Pattern parameter to set wildcard matching for procedure names.
List
A string list object, created and maintained by the application, in which the stored procedures names will be return to.
Description:
Call GetStoredProcNames to obtain available stored procedures list. Strings are sorted by names.
Examples:
var str:string; list:TStringList; i:integer;
begin
MySQLDatabase1.GetStoredProcNames('', list);
str := 'Existing procedures:'+#13#10;
for i := 0 to list.Count-1 do
str := str + ' ' + list[i] + #13#10;
ShowMessage(str);
end;