Token Programming
Defined Tokens
11-12 Strata CIX Voice Mail Programming 01/07
N( )
Update database record–the N( ) token enables you to update the values of a database record. It
searches a file for the first record that has s-value in s-field. It updates the record by placing n-value in
r-field, and then saves that record back to the database.
Syntax N(file,s-field,s-value,r-field,n-value[,r-field,
n-value...])
where:
file dBase file (.DBF) or ASCII file with columns separated by commas (comma delimited).
Valid DOS file name. Can be a variable.
s-field Search dBase file field name or ASCII file column number. (1 is the value of the field
before the comma.) Can be a variable.
s-value Search alphanumeric string. Can contain %S variables.
r-field Replacement dBase file field name or ASCII file column number to update.
n-value New alphanumeric string. Can contain %S variables.
Examples
Suppose an ASCII file contains a listing of dealers, available parts, and orders on those parts. You
could use the R( ) token to obtain information about how many parts the dealer wants to order and
then use the N( ) token to update the database.
R(G1,%S1,40)
G1 Plays greeting 1: “Please enter your dealer number.”
%S1 Stores the caller’s entry in variable %S1.
40 Waits 4 seconds (40 ÷ 10 = 4) for DTMF after playing the greeting.
R(G2,%S2,20)
G2 Plays greeting 2: “Please enter the number of telephones you want to order.”
%S2 Stores the caller’s entry in variable %S2.
20 Waits 2 seconds (20 ÷ 10 = 2) for DTMF after playing the greeting.
R(G3,%S5,20)
G3 Plays greeting 3: “Please enter the number of key systems you want to order.”
%S5 Stores the caller’s entry in variable %S5.
20 Waits 2 seconds (20 ÷ 10 = 2) for DTMF after playing the greeting.
N(ORDERS.DOC,5,%S1,9,%S2,12,%S5)
© Searches ORDERS.DOC for the first record that has the value of %S1 in field 5.
© Replaces the current value of field 9 with %S2.
© Replaces the current value of field 12 with %S5.
© Saves the record back to the database.
Table 11-3 Defined Tokens (continued)
Token Description
To Next Page
Loading...
