Differences

This shows you the differences between two versions of the page.

--- a_f:a:exec_sql [2022/09/01 01:23] – ↷ Page moved from a_f:3100_actions:exec_sql to a_f:a:exec_sql administrator
+++ a_f:a:exec_sql [2025/06/12 03:59] (current) – Change to AwareIM aware_support3
@@ Line 1: / Line 1: @@
-{{tag>Actions Action_List Process SQL Query}}
+{{tag>Index Action Action_List Process SQL Query Version:v8.4}}
 ====== EXEC_SQL ======
@@ Line 10: / Line 10: @@
 where ArithmeticExpressio defines a string to be executed, for example:
-<code aim>EXEC_SQL `UPDATE CRM_Customer SET Name='John'`</code>
+<code aim>EXEC_SQL `UPDATE CRM_Customer SET Name='John'` </code>
 If SQL to be executed performs a SELECT specify the object name that the SQL returns.
@@ Line 16: / Line 16: @@
 ===== Example =====
-<code aim>EXEC_SQL `SELECT CRM_Customer WHERE FirstName=Jane'` RETURN Customer</code>
+<code aim>EXEC_SQL `SELECT CRM_Customer WHERE FirstName='Jane'` RETURN Customer </code>
-You have to be careful when using this acton as you can stuff up your database if you do something wrong. This action is only recommended for advanced users who understand how Aware IM manages the database.
+You have to be careful when using this acton as you can stuff up your database if you do something wrong. This action is only recommended for advanced users who understand how AwareIM manages the database.
-The identifier after ''OF'' can be used to identify a particular database environment, defined when connecting Aware IM to external databases. If not present the native Aware IM database is used
+The identifier after ''OF'' can be used to identify a particular database environment, defined when connecting AwareIM to external databases. If not present the native AwareIM database is used
+<callout type="primary" title="note" icon="true">In the example above Customer is a virtualised object and can be viewed but cannot be brought into context to interact with it.</callout>