Hello Everybody
I createte a solution that show information about our datamodel.
Tables,columns,primary keys,foreign keys,…
The solution is based on 2 views(viewcolumns,viewtables) from our database.
From the local designer everything works as expected.
But when i try to import the solution into our application server i get this:
[error] Reserved words used as table or column names: columns: privileges type comment dynamic mode dec default comment;
What do i miss?
Where to look for the unwanted columnname? (which log)
Why does the solution work on my local maschine ??
Best regards
Albert
Hi Albert, if you open the table from Developer you will see the columns that has a reserved word as name in orange background; at least in Servoy 6 RC2.
Maybe this can help you.
Hi Albert,
Like what Juan said, you can see what column is using a reserved word in the table views. (This functionality has been there since the beginning or so)
That said, you can override the warning and still import your solution if you think it is save by checking the checkbox “Allow reserved SQL keywords as table or column names (will fail unless supported by the backend database)” in the servoy admin page (assuming you were importing it into Server).
Hope this helps.
If I were you, I wouldn’t use reserved words. The list of Servoy’s Reserved keywords is here:
http://wiki.servoy.com/display/public/D … d+keywords