Salesforce

SQL Command Automatic Program Generator (Magic xpa 2.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

SQL Command Automatic Program Generator (Magic xpa 2.x)

The SQL APG utility constructs a complete Magic xpa program from SQL statements that the programmer inputs. Running the SQL APG is the only way to check the SELECT statement syntax before running it. The utility generates a Magic xpa task structure based on a SELECT statement or a stored procedure.

The generated task contains the following items:

  • The original SQL Command

  • Virtual variables and virtual field definitions for all the result table’s columns

  • A full Output Argument table with the automatic virtual variables

  • A default form for user interaction

The developer only has to define Input arguments for the SQL command if required and change the default form if necessary.

Direct SQL – APG

When you perform an APG action from the Direct SQL command window, Magic xpa creates a new task. If the statement that has a result is defined, then any columns that are selected, and are defined as Unicode fields in the database, are created as Unicode fields.

Reference
Attachment 
Attachment