Switch Unpublished or Published Table to be used by application

To avoid updating the live data during the test run by the unpublished application, you can set the applications to refer differents tabeles(live tables or test tables).
You can change or modify application without affecting published application by this.

Create Published Table

To switch published table, create new table to publish in advance.

  1. Click 'Table management' button in "Manage" screen, and then 'Table management' view is opened.
../../../_images/img_01.en230.png
  1. Select table for development, and then right-click 'Copy table definition' menu.
../../../_images/img_02.en215.png
  1. Set table name to publish in 'Table name' in 'Create table' dialog, and then click 'Create table' button.
../../../_images/img_03.en179.png

Note

In 'Copy table definition', data is not copied.

Attention

In table to publish, set table as same with original column definition. If different column definition is set, published application doesn’t work properly.

Set Switching Table For Publishing

If table to publish is prepared, set 'Switch table'.

  1. Select a application from list in Application management screen, and then right-click 'Publication setting' menu.
../../../_images/img_04.en151.png
  1. Select 'Table switching' tab in 'Application settings for publication' dialog.
  2. Click 'Setting' button in setting list.
../../../_images/img_05.en137.png

Tip

Click 'Unset' button in setting list and then published table is released.

  1. Select table for publishing from table list in 'Table selection' dialog and then click 'OK' button.
../../../_images/img_06.en107.png
  1. Check 'Enable table switching' and then click 'OK' button to save the setting.
../../../_images/img_07.en100.png

Tip

  • When "Read Only" is displayed, it indicates that only the process to be referred to is included, and when "Write" is displayed, it indicates that the processing of registration, update, and deletion is included.
  • Published application refer or update published table instead of table for development.
  • Non-published table can’t be switched. (Table for development is referred or updated)
  • Even if this setting is enabled, when developer runs test, tables being referred or updated will not switch to tables being used after the app is published.
  1. After set application is published, using table is switched.

Attention

  • It is not possible to set tables in the same connected database into another database separately. For example, Table X and Y in database A can be set into database B. But it is not allowed to set table X in database B and set table Y into database C. That is why it can’t switch if table X and Y is joined.
  • Even if exclusive control is set for table updating in default database, after setting relation with different database, the exclusive control is disabled.

Important

To switch tables, users require the following permissions.

  • Application author

And also, application author needs the following permission to tables.

  • Administrator
../../../_images/celf_help_mascot54.png