Servoy Forum

In this thread, we talked about using views to minimize DB Selects from Servoy for table forms with a lot of related fields:
https://forum.servoy.com/viewtopic.php?f=22&t=21763

For testing purposes for that thread I created a test view _v_test in my normal solution.
When I installed the new update for my customers today, I noticed that Servoy automatically created a table _v_test on their DB server, which it should not do.

We have a dozen of other views alive for some Jasper reports, where this did not happen.
For _v_test I did set the RowIdent Column to "row ident", because Servoy complained about a missing PK (see other thread at the end), that was the difference to the other views.

Is there a way to avoid this auto-creation of a table when using a view?

Isn't that what the "Skip database views import" option is for?

If a view doesn't exist, Servoy will create a table instead. Usually, you create a view manually in the target DB before you deploy a solution using that view. Then nothing is created.

Thank you, that is easy.

Is "Skip database views import" an option only in Servoy 8 ?
Because I can not find it in Servoy 7 in http://localhost:8080/servoy-admin/solutions/import

That could be, yes.