Reserved words

[jos@devoon.nl]

When I connect a solution with a MSSQL db (skip system tables enabled) there is always an error on importing the solution in the application server:

'Reserved words used as table or column names: tables: domains; columns: module_name'

It is impossible to import the solution without checking:
'Allow reserved SQL keywords as table or column names (will fail unless supported by the backend database)'

Can anyone explain this?

[kwpsd]

Hi, Jos.

'Reserved words used as table or column names: tables: domains; columns: module_name'

The message is telling you that your table name 'domains' is a reserved keyword. Reference the URL below for more details:

https://wiki.servoy.com/display/public/DOCS/Reserved+keywords;jsessionid=7497A2D82F9E5F573C1331084DC92510

I hope this helps!

[jos@devoon.nl]

Hi Kim, Thanks for your reply, so far the only one
But that is not my point. My point is that I respect all those reserved words: I dont have tables or columns named 'domain' etc. But nevertheless Servoy is complaining. A mssql database creates these tables automaticly and uses it undoubtly for its own bookkeeping. I would expect Servoy to ignore these tables and for most of it it does. Except for this one... (I always check 'skip system tabbles' in the database connection)

[GabrielWyss]

Hi Jos
If you select the option 'Export all tables from referenced servers' while exporting your solution, with a SQL-Server there will also exported some System-View. Regardless of whether the option 'Skip System Tables' is set or not. Perhaps, this is your problem.

[jos@devoon.nl]

Hi Gabriel,
That must be it. I have to check that option, otherwise some tables that are needed will be ignored.
So be it...
At least I know now why!
Tnx