SQL Command Automatic Program Generator (Magic xpa 4.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.
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.