Can't interpret solution import warning

Classic Servoy
1

Hi

I get the warning as seen in the attached screen shot when importing a solution into the Servoy Application Server.

Can anyone help what that means?

Regards, Robert

Mac OS X Server 10.6.7
Java build 1.6.0_26
Database SQL Anywhere 12

solution import warning.png
solution import warning.png819×643 198 KB

2

It means that in one of your tables (statistics) you are using a column name that is a reserved word (version). That name might not work in all databases.

3

I think that this means that you have column names with reserved words in the table statistics.

As you can see it is a warning because some DB engines allow that.

Check the statistics table and you will see columns with an orange background.

4

Hi Robert,

this means you have used an SQL-reserved keyword as table or columnname.
depending on the database you use, this shouldn’t have to be a real problem (that’s why it displays as a warning)
on the other hand: you’ll never know whether you might do a future switch to a different DB that does care about it.
To be on the safe side, I’d suggest you find out which table- or columnname this is and change it while you can.

Hope this helps.

5

-:slight_smile: -:slight_smile:

6

3 in row…I guess the answer must be true ;)

7

@ROCLASI, could you elaborate?
Do you think that it means that Robert has used reserved words in his statistics table?
Come on, spell it! ;)

8

Looking at this thread it’s statistically viable that the answer that he used a reserved word in his statistics table is true. :twisted:

But now you ask me…well…he used a reserved word in his table yes. ;)
And looking at the error it seems more than one.

9

Thank you all for the answer

Just now as you all answer I see that it looks like the line above the warning belongs also to the warning text, and makes now more sense, just overlooked that :oops:

Regards, Robert

10

It’s because the warning is not about the 30 characters limitation, but about reserved keywords.
For example, have a look at this list (probably not exhaustive): http://www.aisintl.com/case/library/resword.html

Some reserved words might be accepted by one database and rejected by another.
Servoy being database agnostic is just warning you that you might have trouble using these keywords depending on the DB.
It’s up to you to make sure that the table and field names you use are accepted by your database vendor, and if you think of migrating to another DB, that’s the kind of thing that you will need to check.