Auto Sync with DB for fields with seqeunces..

Classic Servoy
1

With AutoSync we wonM-4t have to sync all the fields that have a seqeunce on each import/export of a solution..

Maybe an “AutoSync all sequences” in the prefs ?! Or as property ?

Rainer

2

I don’t understand your problem, the only time the sequence can be out of sync is when you externally insert data into the tables (import/export does not do this)

3

Maybe Jan, I can add something to this.

Ofcourse you are right but… Let’s assume I am working on the solution to create a new version. My customer works with the version he has.

Now I upload my new version of the solution and bingo. There is an issue because my version of the solution created keys and are now out of sync with the customers database.

If I am correct I now have to check all pk’s just to be sure nothing goes wrong…

4

Your assumption is not correct, an solution export does NOT contain sequence numbers (only the type of sequence on columns), my prevoius statement stays :)

5

  1. I have a blank / clean installation of Servoy at my office to show my programming results.

  2. At home on another computer i have the developer installed.

// I am using an external SQL Server located somewhere else.
// Creating some records in the SQL DB Synced fields e.g. invoice #

  1. I export my work at home and mail the export file to my office.

  2. Next day I import the solution at my office to show progress

  3. Everythink works fine. Only the Sync fields are starting again at “1”

  4. I have have to sync every field otherwise i get duplicate db entries.

  5. I havenM-4t found any solution for this problem :(

Rainer

6

yes that is a problem.
We wil look if we can make a “synch sequences” button on the admin pages of the server (and maybe one in the preference panel of the developer)

7

This feature has been added to the DB servers page of the admin pages and will be available in RC9.

8

Keep to good work going on :)