6.1 Synchronize Wizard and Sequences

[gdurniak]

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

[rgansevles]

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

[gdurniak]

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?

[rgansevles]

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

[gdurniak]

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 ?

[rgansevles]

Greg,

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

Rob