Salesforce

Behavior of Direct SQL SELECT Statements (Magic xpa 2.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

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.

Online vs. Batch

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.

Related Topics

Result Database

Reference
Attachment 
Attachment