- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This action will let you execute a SELECT query against an external database, loop over the results and provide access to the columns returned.
Choose a Database Server IP Address to connect to.
Choose the Type of Database that this is: MySQL or Microsoft SQL Server.
Choose the name of the Database to connect to.
Choose the username that has SELECT permissions to the database.
Choose the password for the aboce user.
Choose the port to use to connect to the database.
Build a query to execute. This query will be executed, and then the results looped over, providing access to the columns returned for each row as the loop proceeds.
Enter the column names this query will return, command seperated. For example “SELECT * FROM Contacts” might return “firstName,lastName”.
Useful as a comment, this description will overwrite the automatically generated description in the Action Manager.