Events tab

The Events tab allows you to view and modify the scripts that were generated by the Create Synchronization Model Wizard. It also allows you to create new scripts.

The Events tab shows all the event scripts for the synchronization model. Use the following options to navigate the events listing:

  • Group   Shows the name of the group associated with the displayed events. Choose a group from the dropdown list to scroll the editor to that group's events. The dropdown list contains one event group for all connection events, and one event group for each remote table's events.

  • Event   Shows the event name. Choose an event name from the dropdown list to scroll the editor to the specified event. Bolding indicates that the event has a script associated with it. If you select an event that is not bolded, then a new script will be added to the editor.

  • Type   Shows whether the script is generated, overridden, or user-defined.

    • Generated scripts   Generated scripts are automatically created and maintained as a result of the selections you make in the Create Synchronization Model Wizard.

      You can edit and even delete the contents of a generated script. When you make changes to a generated script, its type changes to Overridden.

    • Overridden scripts   Overridden scripts are scripts that have been manually changed.

      When you change a generated script, the script is fully under your control; it is not changed automatically when something is changed in Model mode. For example, if you change the download_delete_cursor script for a table and then clear Download Deletes in Model mode, your customized download_delete_cursor script is not affected. However, its type will be changed to User-Defined.

      You can restore an overridden script back to its generated-script state by placing the cursor anywhere within the script and choosing File » Restore Scriptname Script. You can restore multiple overridden scripts at once by selecting the scripts in the editor and choosing File » Restore Selected Scripts.

    • Ignored scripts   Ignored scripts are scripts that have been manually set to be ignored. See Ignored scripts.

      You can set a script to be ignored by placing the cursor anywhere within the script and choosing File » Ignore Scriptname Script. You can ignore multiple ignored scripts at once by selecting the scripts in the editor and choosing File » Ignore Selected Scripts.

      You can restore an ignored script back to its generated-script state by placing the cursor anywhere within the script and choosing File » Restore Scriptname Script. You can restore multiple ignored scripts at once by selecting the scripts in the editor and choosing File » Restore Selected Scripts.

    • User-defined scripts   User-defined scripts are scripts that you create for events for which there are no generated script.

      User-defined scripts are not changed automatically when something is changed in Model mode. For example, if you create a download_delete_cursor script for a table and then select Download Deletes in Model mode, your customized download_delete_cursor script is not affected. However, its type changes to Overridden.

      You can remove a user-defined script by placing the cursor in the script and choosing File » Remove Scriptname Script. You can restore user-defined scripts by selecting event names and choosing File » Restore Selected Scripts.

  • Language   Shows the language the event script is written in. Languages supported are SQL, JAVA, and .NET; all generated scripts are SQL scripts.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1