Avaya 6 사용자 설명서

 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.

1. Click the 

 Database Actions icon and select 

 Database Execute.

2. The 

, 

, 

 and 

 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". 

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