Differences

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

--- a_f:f:af:exec_spf [2022/09/02 02:51] – removed - external edit (Unknown date) 127.0.0.1
+++ a_f:f:af:exec_spf [2023/05/09 00:51] (current) – sean
@@ Line 1: / Line 1: @@
+{{tag>Index Function Function_List Mathematical Version:v8.4}}
+====== 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 ''[[a_f:f:af:as_number|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>