Run SQL Query

The Run SQL Query command executes an SQL query and retrieves the results. This command is restricted and may only be executed when the user of is logged in to the Digital Storage Manager or Virtual Ticket desktop client as the Administrator.

Run SQL Query sql_statement

Result: results_list

Example: Determine the MetaCommunications database type.

tell application "Virtual Ticket 8.0"
set queryResults to ¬
Run SQL Query "select application_family from database_state"
set databaseType to application_family of item 1 of queryResults
end tell

Example: Obtain a list of customers.

tell application "Virtual Ticket 8.0"
set customerList to ¬
Run SQL Query "select Customer_Code, Customer_Name from
Customers"
end tell