primary keys and different applications

Classic Servoy
1

Hello Forum,

I have Servoy connecting to a MySQL data server and 1 of my tables has a PK- I am using Servoy to Add records to the database, but there is an auto enter/increment option for that field in Servoy that gets updated whenever I insert a new record from servoy. But I also have a web application that will be using the same database and adding records also. If my web app adds a record, the auto-enter for that field in servoy does not get updated, then the next time I try to enter a record in Servoy I get a duplicate Key error. Anyone know a way around this?

thanks again

2

ok guys- i think i got it- maybe the answer is as simple as turning off the auto-enter option in servoy!?

3

in 2.0 you can use a database sequence for that if you use mysql then you can have a auto increment pk. And configure that pk column as a database sequence.