Remove tutorial materials from your computer.

To remove tutorial materials from your computer

1. Return the ULCustomer table upload_insert and download_cursor scripts to their original SQL logic.

   1. Click Start » Programs » SQL Anywhere 11 » Interactive SQL, or run the following command:

      dbisql

   2. Click the Identification tab.

   3. Click ODBC Data Source Name and type SQL Anywhere 11 CustDB.

   4. Click OK.

   5. Run the following commands in Interactive SQL:

      CALL ml_add_table_script( 'custdb 11.0', 'ULCustomer', 'upload_insert', 'INSERT INTO ULCustomer( cust_id, cust_name ) VALUES( ?, ? )' ); CALL ml_add_table_script( 'custdb 11.0', 'ULCustomer', 'download_cursor', 'SELECT "cust_id", "cust_name" FROM "ULCustomer" WHERE "last_modified" >= ?' ); COMMIT;

2. To close the SQL Anywhere, MobiLink, and synchronization client windows, right-click each taskbar item and choose Close.

3. Delete all tutorial-related Java sources.

   Delete the folder containing your CustdbScripts.java and CustdbScripts.class files (c:\mljava).

   Note

   Ensure that you do not have any important files in c:\mljava.

4. Reset the database for the Windows Sample Application.

   Run the following command from the samples-dir\UltraLite\CustDB directory:

   newdb.bat