Cleanup

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. Open Interactive SQL.

      Choose 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 to connect.

    5. Execute 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" >= ?' );
  2. Close the SQL Anywhere, MobiLink, and synchronization client windows by right-clicking each taskbar item and choosing Close.

  3. Delete all tutorial-related .NET sources.

    Delete the folder containing your CustdbScripts.cs and CustdbScripts.dll files (c:\mldnet).

    Note

    Ensure that you do not have other important files in c:\mldnet.

  4. Reset the database for the Windows Sample Application.

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

    newdb.bat