Problem with updatable-view on MS SQL-Server

Classic Servoy
1

Hi,
I defined in MS SQL-Server a VIEW for 2 tables with a join. I want to update 2 fields in the “first” table.
In developer first I’ve got a message “Caused by: com.servoy.j2db.persistence.RepositoryException: Es muss mindestens eine Schlüsselspalte exisitieren ‘log_crd_view’” <== means: there must be a Key-Row
I solved that problem in Developer/Resources/Database Servers/MySolution/Views ==> here I defined a “row_ident” for the key field.
After that it worked as expected.

Now I want to activate this at my customer.
I created the views for the MS SQL-Server (The views are working and they are updatable)
I stopped and started the servoy-application-server
I imported my solution.

Now I get the same message (as before in Developer)
“Caused by: com.servoy.j2db.persistence.RepositoryException: Es muss mindestens eine Schlüsselspalte exisitieren ‘log_crd_view’”

Is it a bug or what have I to do that the “row_ident” is known to the servoy-application-server???

Thanks for help
Harro

2

Hi,
I think it is aBUG. I reported it to SERVOY

I updated the repository as follows:
update [servoy_repository].[dbo].[servoy_columninfo]
set is_row_ident = 2
where tablename like ‘log_%_view’ and columnname = ‘log_id’

I restarted servoy-application-server.
I imported the solution again (Don’t know if really necessary)
tatatahhh ==> now it works

Have a nice weekend.
I’m happy that I could solve it before weekend starts.
Harro