db.Skip() - IVR Database Function | Xtend IVR Tutorial | Database Plugins

$alias = db.Skip ()

Populates the values of the succeeding record into dynamic variables after advancing the record pointer.

Parameters

None.

Return Value

Returns 1 if successful, else 0.

Remarks

Skip() functions in the following manner:

Skips to the next record in the previously populated recordset object created by db.Open.
Creates dynamic variables, if required.
Control returns to the main function.

The plugin should be preceeded by an Open().

Operation of the plugin solely depends on the LHS variable which should be the same as that in Open().

Only the errors pertaining to the syntax will be directed to the ONSYSTEMERROR. All other errors will return FALSE by setting the $error variable.

LHS variable is necessary and compulsory for the proper functioning of all database functions. Hence the following loop statement will generate $error variable:

Example

:MAIN 
	display "Waiting for call" 
	answer  
	
	$Provider= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Product.mdb;Persist Security Info=False"  
	
	display "Displaying records from the table"
	$alias = db.Open($Provider,"SELECT * FROM Product") 
	
	while $alias.eof = FALSE 
	    display $alias.id $alias.product $alias.productName 
		sleep 1000
	    $alias = db.Skip() 
	endwhile
	
	Display "End of the table"
	
	$alias = db.Close()
	hangup 
	goto MAIN 
	
	:ONSYSTEMERROR 
		hangup 
		MsgBox($error) 
		log $error
		$alias = db.close() 
		goto MAIN

In the script, an ADO connection is established with the database "Product.mdb". The records are displayed by executing the Select query in Open(). The first record appropriate for the query given, is returned and stored in dynamic variables through $alias. Values in the record are accessed as $alias.id, $alias.product and $alias.productName where id, product and productName are the fields in the table "Product". To move forward and populate the next record, we use Skip(). This continues until End of file is reached.