Using the Sequence Editor form

You can use the Sequence Editor form to change the sequence number for a Create Rule Sequence Segment. This form is only used for rules that have a Segment Type of Sequence.

The Sequence Number is the last used sequence number that was generated by the Create Rule.

The Sequence Editor form is not a part of any form group and must be placed on a menu. To modify the sequence, the role must have the appropriate form security of read/copy/write.

If you are importing many objects from another database, this form is ideal. You can use this form to change the sequence to a number other than 1.

You can only use the Sequence Editor form with SQL databases. You can use a separate function to manage Sequences in Oracle databases.

Adding the Sequence Editor form to the Menu bar

  1. Open the Menu form.
  2. Select the lab to add the Sequence Editor form to.
  3. Drag and drop the form to a menu in the Existing Menus pane. Click Save. For more information, see Form assignments.

Assigning form privileges to the role

  1. Open the Role form.
  2. Add the Sequence Editor form, FRMSEQUENCE, to the Form Security tab.
  3. Select read/copy/write from the Security Level field. Click Save.

Setting up a Create Rule for the Sequence Editor

  1. Open the Create Rule form.
  2. Create a new Create Rule. For more information, see Process for creating a rule.
  3. Specify Sequence for the Segment Type.

    Setting up create rule for the Sequence Editor

  4. Specify a value in the Enum Query/Seq field. The specified value is defined as the Set Type in the Sequence Editor form. Click Save.
  5. Optionally, specify a numeric value in the Sequence Start Value field if you want your sequence to start with a value other than the default of 0. This value is used to set the initial value for the Sequence Number for a Create Rule.

Changing the Sequence Number

From the object form, use your Create Rule to create another object. A sequence number is generated for the new object when the new object is saved to the database. Now, the last used number is displayed in the Sequence Editor form. If the Sequence Editor menu option is selected when there are no sequences defined in Create Rule > Sequence Segment type and you do not use a Create Rule to create an object, the user will be brought to the Home Page.
  1. Open the Sequence Editor form.
  2. Select the Set Type.
  3. Change the Sequence Number. Click Save.

    Changing the Sequence Number