MigsLab MySQL · Types · Procedures and functions
ArxProcedureType
Definition
- Namespace
ARX.SDK.Query- Package
ARX.SDK
public enum ArxProcedureTypeWhat a routine is: PostgreSQL calls them differently (CALL against SELECT), so the caller says which.
Values
ProcedureA stored procedure:
CALL name(...). Returns OUT values and, through cursor parameters, tables.FunctionA function:
SELECT * FROM name(...). Returns rows (a value, a row of OUT values, a table, a set).
Usage
A line from a verified sample; the full, runnable code is on its page.
var count = new ArxProcedureExpression("fn_order_count") { ProcedureType = ArxProcedureType.Function };Functions in depth on MySQL: tables, procedures and scalar values instead of row sources, scenario 3
Used in:
- Functions in depth on MySQL: tables, procedures and scalar values instead of row sourcesRetrieveMultiple
- Call a function: a value, rows, an effectExecute
- Page through a procedure's result: the procedure pages itself, ARX pages a result setExecute
- Execute on a preloaded, Strict schema: routines aren't covered, tables areExecute