User`s guide

7 Functions — Alphabetical List
7-144
'Engine Kit'
'Painting Set'
ans =
'Space Cruiser'
'Building Blocks'
ans =
'Tin Soldier'
'Sail Boat'
ans =
'Slinky'
'Teddy Bear'
ans =
'No Data'
After finishing with the cursor object, close it.
close(curs)
Import Data with an Absolute Position Offset Using the Scrollable Cursor
This example assumes you are connecting to a MySQL database that contains a table
called productTable. This table contains 15 records, where each record represents one
product.
Connect to the MySQL database using the native ODBC interface. This code assumes
you are connecting to a data source named MySQL with user name username and
password pwd.
conn = database.ODBCConnection('MySQL','username','pwd');
Select all products from the productTable table and sort them in ascending order
by product number. Create a scrollable cursor using the name-value pair argument
'cursorType'.