Universal Database Reference

To get a safe and quick access to your database system over phone, Xtend IVR introduces a sample script which allows callers to retrieve information, add, modify and update information directly into the database.

Download the evaluation version of Xtend IVR and install the telephony application in your system. Run the sample script from the Script Editor. Click here to refer the code.

The automated attendant will work as given below:

• Perform the database related functions like adding, deleting, editing, finding and navigating through records depending on the user choice
• When an employee name and address is entered, IVR inserts the entry into the table using the function INSERT
• IVR retrieves the data from the table using the function SELECT
• Record updation is carried out through UPDATE query
• Deletion of records can be carried out through DELETE records

Download the source file for the Universal Database Reference

**** This script is not meant for running in Xtend IVR Standard Edition.
**** This simply demonstrates how the database functions work. 
**** No call related commands like ANSWER,HANGUP etc are used.
**** You can try single stepping in Xtend IVR Developer mode to see the code flow

;Methods for 
;1. adding records
;2. deleting records
;3. editing records
;4. finding & navigating through records

; All the above operations are done using standard SQL statements
; To know more about the Database Architecture,
; please refer "Database Plugins" in Xtend IVR help

MAIN:
	// a break point is introduced so that you can step the code
	bp
	
	; You can use ADO or ODBC to access your database.
	; If you use ADO, use the ADO connect string.
	; If you use ODBC, use odbc DSN.
	; Any database that support ADO or ODBC can be accessed
	; using the Xtend IVR "db" plug-in
	
	// Sample ADO Connect strings for various databases are available on
	// http://support.microsoft.com/default.aspx?scid=kb;en-us;326548
	// http://www.sqlstrings.com/
	
	
	; ADO connect string for MS Access 2000 database db2000.mdb
	$db = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db2000.mdb;;User Id=admin;
								Password=;"
	
	; Create DSN and use the DSN instead of ADO connect string to access via ODBC
	; $db = "db2000.dsn"
	
	; Add a new record. (Returns the number of records added)
	; INSERT INTO <Table> (Field1,Field2) VALUES (val1,val2)
	$sql = format("INSERT INTO Employee (EmpName,Address) VALUES ('%s','%s')","George",
								"White House")
	$stat = db.RunSQL($db,$sql)
	if $stat = 0
		display $error
		log $error
	endif
		
	; Find and Navigate through the recordset
	; SELECT * from <Table> where Field1 = 'Value'
	$sql = format("SELECT * FROM  Employee WHERE EmpName = '%s'","George")
	$alias = db.Open($db, $sql)
	if $alias
		while $alias.eof = FALSE
			display $alias.Address
			$alias = db.Skip()
			; db.Skip() can be used only with db.Open()
		endwhile
		$alias = db.Close()
	endif
		
	; Edit/Update a record. ( Returns number of records affected. )
	; UPDATE <Table> SET Field1 = 'NewValue' where Field1 = 'OldValue'
	$sql = format("UPDATE Employee SET EmpName = '%s' WHERE EmpName = '%s'",
							"Alexander","George")
	$stat = db.RunSQL($db,$sql)
	if $stat = 0
		display $error
		log $error
	endif
	
	; Delete a record. ( Returns number of records deleted. )
	; DELETE from <Table> where Field1 = 'Value'
	$sql = format("DELETE FROM Employee WHERE EmpName = '%s'","Alexander")
	$stat = db.RunSQL($db,$sql)
	if $stat = 0
		display $error
		log $error
	endif
	goto MAIN
	
ONSYSTEMERROR:
	display $error
	log $error
	hangup
	goto MAIN
	
* End of Script