6.1 Synchronize Wizard and Sequences

Classic Servoy
1

From Quick Fix, I just used the Synchronize Wizard to generate a missing dbi file

it set the PK to servoy seq, while that Sybase 10.0.1 column is set to autoincrement

is this correct ?

greg

2

Greg,

Servoy tests each table if the pk is autoincrement, regardless of the pk setting.
If you create new records, which is actually used?

Rob

3

if Servoy “tests each table”, then the “bug” is minor. It’s just not displayed properly

( but then the Wizard should “test each table” too )

The “next” serial number is the same, so hard to tell which wins out

greg

Servoy tests each table if the pk is autoincrement, regardless of the pk setting.

If you create new records, which is actually used?

4

Greg,

For servoy-sequence in developer we do a select-max to find the next value (in ApplicationServer the sequence is managed by the repository).

You could create a few new records, say ids 1, 2, 3
then delete 2 and 3, restart developer and then create a new record.

in developer, servoy sequence will generate 2, your autoincrement will probably generate 4.

Rob

5

if you create the record in Servoy, the Servoy Seq is used ( which was a surprise )

if I create the record in Sybase Central, the autoincrement is used

this could be nasty if they get out of sych, e.g. by deleting some records, as you suggested

greg

If you create new records, which is actually used ?

6

Greg,

What happens if you export this solution to an application server, which sequence will then be used?

Rob