Support Center - Help topic

Home > Support Center > Search > Help Topic
Contact Us
Can't find what you're looking for in our Tech Support Library? Send us a message.
Contact Us
Interfacing with an SQL database table: the SQL Advanced Query Object vs. Macro
Tags: SQL cMT Data Macros SQL

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 Derek Thompson