SequenceField - Which one to choose?

J

jpchausseau

Member²
1- When defining the SequenceField for a TOracleDataSet, a choice must be made of a sequence in the dialog box. What do all those choices mean? Since the database I am creating will be exported and installed to customer's existing Oracle setups, is there a specific 'best' choice?

2- When using SequenceField, are there any risks that the sequence may not be reliably sequential (!), that is that some numbers may be missed in the process (like 1,2,3,4,11,12,etc.) specifically in a multi-user (50 users) environment?

Thanks for taking care of answering,

Jean-Paul
 
1. You probably need to specifically define a sequence for this column, and select it in the SequenceField property editor. There is usually a 1 to 1 relation between a sequence and a column.

2. You always have the risk that gaps occur. If you want to minimize the risk, you need to set the ApplyMoment to amOnServer, and set the cache value of the sequence to 1. If you want to avoid the risk, you cannot use a sequence but must implement your own sequence generator functionality.

------------------
Marco Kalter
Allround Automations
 
You must log in or register to reply here.
Back
Top