Filter
Top Products
Voicemail Pro Installation and Maintenance Page 251
15-601063 Issue 22e (16 May 2010)IP Office Release 6
Voicemail Pro Actions: Database Actions
4.10.2 Database Execute
The Database Execute action performs an SQL query on a database opened on a preceding Database Open action.
An SQL query that is generated by the Database Execute Action does not support spaces in field or table names. To avoid
problems in a Microsoft Access database, it is advisable to avoid using a field name that has the same name as its field
type. For example, you should avoid using the name Number for a number field.
· In addition to the normal licenses for Voicemail Pro , use of database actions requires the IP Office system to
have an Advanced Edition license. For systems upgraded to IP Office Release 6, existing legacy VMPro Database
Interface licenses can still be used.
Settings
1.
Click the Database Actions icon and select Database Execute.
2.
The General , Entry Prompts , Reporting and Results tabs are standard tabs available to all
actions.
3.
Select the Specific tab. The SQL Wizard window opens. Use the wizard to construct the SQL query.
· You must ensure that any data included in the query matches the data type (number, integer or text) of the
field it is being used to query. Values being used to query a text field should be enclosed by quotation marks.
This applies whether using query values entered directly or using Voicemail Pro variables. For example, if
using $KEY as a query value, for a text field query ensure that you enter "$KEY".
Results
This action has the following results which can be connected to further actions:
· Success
The action has been successful and has returned a set of records from the database.
· Failure
The action has not returned any data.
The Database Execute action results can only be Success or Failure. Add connections to relevant actions. For an example
of the action in a call flow, see IVR Database Connection Example, Retrieving Data From the Database and Entering
Details in to the Database .
22
176 177 182 183
366
372