Tutorial :AEP help needed



Question:

Can the AEP Stored procedure functions have additional paramenters added?


Solution:1

If I understand what you are asking, the answer is yes. You can use the ALTER PROCEDURE statement to add a parameter to an existing AEP. For example,

ALTER PROCEDURE MyAEP (         num Integer,        newparam Integer     )      FUNCTION        "TestSP"     IN COMLIBRARY        "AdvantageAEP1.aep_procedures";  

You would also need to update the procedure itself to make use of the parameter.

As far as the function itself in the DLL or assembly, you cannot change the parameter list. The server expects a very specific prototype for the function.


Solution:2

Assuming you are wondering how to send parameters to the stored procedure and then read them, you create your function with as many parameters as you need. The .NET assembly that you build to be called when your execute the stored procedure gets very specific parameters itself (as was mentioned by Mark).
Your task is to use the connection that you are passed to open the __input table and read the parameter values that are stored there, and operate on them as you need to.
If you get the help file as of 9.1 (I believe) where all of the help is in one file, you will find Cary Jensen's book ALSO included, and he has a couple of sections in Chapter 7 on writing stored procedures using .NET via C# and VB.Net


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »