Servoy DB-Manged Primary Keys and ERD Tools Don't Mix?

Classic Servoy
1

Hi,

I want to use database-managed Primary Keys with tables in a MySQL database created by a 3rd party ERD tool (Artiso’s Visual Case). I can’t set the Primary Keys as ‘database identity’ (ie: database managed) and get the error, ‘Sequence type Database Identity can only be specified if the table is not yet created in the database’.

Unless I’m mistaken, this pretty much means you can’t use database-managed Primary Keys with pre-existing tables – they have to be created from within Servoy.

Any plans to change this? ERD tools allow converting to different database vendors, managing foreign constraints, indexes, and so on…

Thanks.

2

removed that check.
You can always set a dbidentity now

3

Cheers,

I posted before I went to bed and wake to find my request has been implemented! Really, this is most uncommon and very impressive.

Almost certain we’ll be making a purchase very soon, and using our ERD tool will be a big help.

Thanks again.

4

Hi,

Just tested, and this is indeed changed in RC7, with a small warning to make sure your key is set to auto increment at the RDBMS level.

Thanks again – a very flexible addition.

Cheers.

5

Does this imply that my questions at http://forum.servoy.com/viewtopic.php?t=781 should be all resolved?

Thanks,
Neale.

6

yes, see answer over there