Salesforce

Stored Procedures Composite Generator (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Stored Procedures Composite Generator (Magic xpa 4.x)

The Stored Procedures wizard displays a list of all of the SQL stored procedures from a given database (that is defined in the Magic.ini) and creates a component that performs a Direct SQL with the relevant parameters and return value.

The following steps will guide you through the Stored Procedures wizard:

  1. Access the composite generators by following the Main Wizard Module steps.

  2. From the Component Selection screen, select Stored Procedure. Click Next.

  3. Fill in the Component Details Display screen. Click Next.

  4. From the Database Selection screen, select the database that you want to contain the stored procedures. This screen lists the databases defined in the Magici.ini file, but only databases defined for the following DBMSs: MS SQL, Oracle, and DB2. Click Next.

  5. From the Stored Procedures Selection screen, select the stored procedures that you want to use. This screen lists the stored procedures that are fetched from the database, which is defined in the Magic.ini file.

  6. While parked on a stored procedure, you can click the View SP button to view the stored procedure content. Click OK and then click Next.

  7. From the Determining the Attributes screen, you can change the format and the picture of the fields. Click Next.

  8. From the Completed Component Details screen, click Finish.

To see what happens once you have finished using the Stored Procedures wizard, see the Generated Stored Procedures Component topic.

You can use the Composite Generator to generate a stored procedure that returns values. You cannot use the Composite Generator for stored procedures that require an Online task to be displayed, such as a stored procedure that selects fields from a table and displays them on the form.

Reference
Attachment 
Attachment