372 .

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 22 , 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 176 , Entry Prompts 177 , Reporting 182 and Results 183 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 366 and Entering Details in to the Database

Voicemail Pro Installation and Maintenance

Page 251

IP Office Release 6

15-601063 Issue 22e (16 May 2010)

Page 251
Image 251
Avaya 6 manual Click the Database Actions icon and select Database Execute