Execute SQL Command performs a SQL statement that is stored in a memory variable.
Because the SQL statement is stored in a memory variable, it can be constructed dynamically, based on results obtained while reading the data. For example, an SQL statement (such as select, insert, or update) can be assigned to the memory variable initially and SQL clauses (such as where or order by) can be added based on conditional logic applied to the data. The advantages of this command are the potential of eliminating the need for unnecessary nested condition testing and the ability to dynamically construct SQL statements based on data conditions (such as information passed from a Web browser to the server).
SQL Application File Name – the name of the file associated with the DSN (Data Source Name) that points to the database being accessed by the SQL statement. (You made the association between the file and the DSN on the File – New/Properties window.)
SQL Application File Record – ECMap’s internal name for the database table that contains the data being accessed by the SQL statement. (When you import an ODBC record definition, ECMap creates an internal record name using the name of the database table whose layout is being used to create the record definition. The corresponding Table Name, Record Name, and File Name appear on the Table Selection window.
SQL Table Name – the actual name of the database table that contains the data being accessed by the SQL statement.
SQL Statement – Memory Variable – contains the dynamically created SQL statement. You begin by assigning a standard SQL statement to the memory variable. To complete the statement, you add SQL clauses by concatenating character strings (such as Where or state = ‘) or record fields (such as state_field) to the memory variable, based on conditions that you apply to the data. The resulting memory variable contains the entire dynamically created SQL statement that is executed.
