Error on exporting solution to file

Classic Servoy
1

Hello,

on exporting a solution to file, I got an error:

Table ‘messages’ of server ‘solutionname’ is not a regular table but a VIEW and will not be automatically created when imported.

Pretty bad, because the table is really not created when imported.

Who can help?

Thanks
Thomas

2

I am not familiar with views but when the message is correct it is not a table. As far as I know views are database specific and can not be recreated by Servoy/Java drivers…

3

IT2Be:
I am not familiar with views but when the message is correct it is not a table. As far as I know views are database specific and can not be recreated by Servoy/Java drivers…

the problem is, the table ‘messages’ should be a table an not view ! The messages table contains the i18n records and was created by servoy automatically.
So really bad if all the i18n entries can not be exported. :(

4

I guess, Servoy is not able to create a table with the name “messages” in MSSQL 2005, since Servoy 3 with MSSQL 2005 shows all the system tables in the Define Dataproviders menu, and “messages” is a system table from MSSQL 2005.

Workaround:
I renamed the tablename for example to " i18n_messages" and configure servoy to use the new name as messages table.

Works fine :D