Differences

This shows you the differences between two versions of the page.

--- a_f:f:99_a:exec_spf [2022/09/01 06:45] – created - external edit 127.0.0.1
+++ a_f:f:99_a:exec_spf [2022/09/02 02:41] (current) – ↷ Page moved from a_f:f:99_a:exec_spf to a_f:f:f:exec_spf administrator
@@ Line 1: / Line 1: @@
-{{tag>Functions Function_List Mathematical}}
-====== EXEC_SPF ======
-===== Description =====
-Executes the specified stored procedure and returns a value in the ''OUT'' parameter of the stored procedure. The stored procedure must have one and only one ''OUT'' parameter defined. All other parameters (if any) should be ''IN'' parameters. The returned valus is of Plain Text type. If you need to convert it to number use the ''AS_NUMBER'' function on the result
-===== Parameters =====
-The first parameter is the name of the stored procedure to execute. The second parameter is the string identifying database environment ('MAIN' for the native one).All other parameters (if any) are ''IN'' parameters of the stored procedure
-===== Example =====
-<code aim>IF EXEC_SPF ('ContactNotesCount', 'MAIN', Customer.ID) = 4 THEN ... </code>