Behavior of Direct SQL SELECT Statements (Magic xpa 2.x)
Some of the Direct SQL statements that have a result database behave differently in Magic xpa.
Direct SQL statement execution always occurs before a task prefix. Therefore, once you have entered the task prefix, the SQL statement has already been executed.
In Online tasks:
-
You must browse on the SELECT statement result.
-
Magic xpa creates a temporary result table/ file and inserts all the records into it so that the user can scroll on the records. The table is deleted at the end of the task.
In Batch tasks:
-
Every record is only read once, and you do not need to go backwards.
-
Magic xpa opens a cursor according to the SELECT statement and retrieves all the records one after the other.
Result Database
