Returns list of routines available at the moment in the current database.
Syntax:
GetRoutinesNames(Pattern: string; List: TStrings; SrtType: TMySQLSelectRoutinesType = srtAll);
TMuSQLSelectRoutinesType = (srtProc, srtFunc, srtAll);
Parameters:
Pattern
Use Pattern parameter to set wildcard matching for functions names.
List
A string list object, created and maintained by the application, in which the functions names will be return to.
SrtType
Specifies which type of routines will be returns.
Description:
Call to GetRoutinesNames to obtain available routines list. Strings are sorted by names.
Example:
var str:string; list:TStringList; i:integer;
begin
MySQLDatabase1.GetRoutinesNames('', list, TMySQLSelectRoutinesType.srtFunc);
str := 'Existing functions:'+#13#10;
for i := 0 to list.Count-1 do
str := str + ' ' + list[i] + #13#10;
ShowMessage(str);
end;