Problem with column called LENGTH

Classic Servoy
1

I have an Oracle table which has a field called LENGTH - its a number(12,7). I know its a lousy column name - it’s a 3rd party table and I cannot change it :?

I created a form for this table but I am unable to save anything in this field specifically.
I seeded a record directly in the database with a value of 3.2 in LENGTH. But when I show this record in my form the value shows up as 0.

If I change the LENGTH value to 5.0 ,for example, and then save the LENGTH value is not changed in the database.

I’m not receiving any errors in the Servoy log so I’m not sure what is failing. I suspect it has something to do with the fact that LENGTH is a reserved word for Servoy (i.e. when I examine the table in Servoy Developer the LENGTH column shows up with an orange background.

Any thoughts on this ?
Cheers

2

A quick workaround would be to create a VIEW with that column renamed to something else, I know it’s not an elegant solution but it can get you out of troubles.