We prepared some views in our database as a necessary base for Jasper reports.
Is there any way we can get rid of the resulting warning messages we get for those views?
I do not want to switch the warning off, as it is very useful when there is a real inconsistency.
Hi Bernd,
You need to create the database information (dbi) file for these views. One way of doing this is to hit ctrl-1 (Quick-Fix) when you have the warning marker selected and follow the dialog.
Hope this helps.
Hi Robert,
so even in this case where I do not have real tables but just views, creating the dbi-files is fine and does not have any drawbacks?
Hi Bernd,
The only drawback is that when you import the solution into a server that doesn’t have these views it will create them (if you let it) as tables.
Yes, I think that is the problem why we did not do the fix so far, as the views need to remain views and should not turn into tables.
Hi Bernd,
Servoy will not change views into tables when you have them already defined as views. It’s just that if it sees you don’t have these database objects in your database it will try to create them. So just make sure you have the views created before you import a solution into a new install.
Hope this explains things.
Ok, that makes sense. Thanks for this additional explanation!
You should probably have a pre-import-hook module that you use to 1) test, if all of your views exist and 2) create the ones that do not. That way you do not have to access any DB server you deploy with.
Right, good idea, thanks Patrick!
