Primari Key problem

Classic Servoy
1

Hi,

I installed 1.1 rc4, I created a connection to a db server (MySQL) I was using with 1.01 and I put all the fields in a form.
When I create a new record, the primary key on the server is not updated and remains empty (even if the field doesn’t allow null values).

Even stranger, if I import from 1.01 a solution based on the same backend, the primary key works fine.

2

Can you check if there is a servoy sequence on that primary key field?

3

I forgot to mention that we don’t have any troubles with mysql.

4

jaleman:
Can you check if there is a servoy sequence on that primary key field?

There was a sequence, but it didn’t work. So, I set it to “none”, but the records were created empty (I thought that “none” meant that the sequence was managed directly from mysql and not from Servoy).
Today, I set again a servoy sequence and it works.

:)

But I’m curious about one thing: if I wanted to be MySQL to take care of the sequence, how should I do (if it’s possible, of course)?

Thanks

5

You can have mysql handle the sequence, but in the current version not on the primary key. We are doing some major work on making database specif sequence support, this functionality won’t make it into 1.1 but in the release after 1.1

To have a sequence handled by the database click on the Value pulldown in the column properties and choose the ‘managed by database’ option.