Interfacing with an SQL database table: the SQL Advanced Query Object vs. Macro

Tags: cMTDataSQLMacros

Interfacing with an SQL database table: the SQL Advanced Query Object vs. Macro

There are no macro instructions that allow a macro to directly interface with table data in a SQL database. The data would need to be copied from the database into local HMI memory before it can be accessed by the macro, which is tedious if large amounts of data need to be manipulated.

It is recommended that whatever operation on table data you are trying to handle in the macro, handling that in the SQL Advanced Query Object.

After all, the fact that the SQL query
object doesn’t allow for copying table data into entire address blocks of local HMI memory was intentional
design.

SQL is a much more powerful tool for data manipulation than the native macro
language, so it should be used whenever possible.

Content Created by Jeff Robertson
Scroll to Top