what is a field with an orange background when displaying table fields? a kind of warning I guess? could not see any difference…
Capital used in column name.
is that illegal? I see many mssql people using camel case names though i hate these (my small finger is lazy)
btw, there must be other reasons because the 2 I see now are lower case… reserved words most probably. but when it’s not your db, stuck…
lesouef:
what is a field with an orange background when displaying table fields? a kind of warning I guess? could not see any difference…
I believe it also relates to column names greater than 32 characters - which makes them illegal in Oracle.
I’ll bet it’s all of the above
ROCLASI:
I’ll bet it’s all of the above
Be nice to be sure though as currently - since we dont use Oracle- we dont care - orange looks nice
But if its a problem …
If your database object names (so tables, columns, etc) have names longer than 30 characters (not 32) then you can’t deploy on Oracle. So it’s not a deal breaker but more of a ‘heads up’.
If you use reserved words for table/column names like ‘password’, ‘user’, etc. then you should know that you need to double quote (“password”) these names in your custom SQL or else they will fail.
If you use camelCasing in your table/column names then you should know that you need to double quote (“myColumn”) these names in your custom SQL or else they will fail. Else these names will be casted to all upper or all lowercase (depending on the backend) in your SQL.
Servoy itself uses Hibernate and Hibernate double-quotes all database objects so it doesn’t have these issues.
So as long as you know (and act upon) this then the orange will be just a nice color.
ROCLASI:
So as long as you know (and act upon) this then the orange will be just a nice color.
Excellent - thanks Robert! SQL Guru.
I would have prefered blue then… but Robert is dutch!
thanks for the tip, just a warning then as this a mssql db.