Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview 

Vienna has introduced option to use DB (oracle or PostgreSQL) sequences to generate new primary key of records. 

Product Version and dependency 

Native Sequence feature is supported by the below-mentioned modules:  

...

 After module is downloaded, System administrator can see a new process in menu having name "Enable Native Sequence". 

Use 

If you wants to use Native sequences of DB instead of Vienna's Sequencing for primary keys values generation, then Login with System Administrator Role. Open menu and search for "Enable Native Sequence" process. 

...

If you wants to see what will be next value for primary key for a table, then execute "Sequence Check" process and open "Document Sequence" window and search for your table. You will see next value for primary key for that table in Current Next textbox. 

...

Once you start using DB sequence, then you will not be able to use Vienna Sequencing in future. 

...