SchemaView incorrect case for calculated fields

[ajith]

In SchemaView, the names of calculated fields are shown starting with uppercase, but any other uppercase is converted to lowercase. Is this intentional?
ajith

[amckinlay]

They are shown capitalized so that you know they are calculated fields.

Within queries you refer to them uncapitalized. This is so you can change between calculated and saved without changing your code.

Where are you seeing uppercase converted to lowercase?

[ajith]

Hello,

From QueryView I tried

create StkTable (stk_first, Stk_second, Stk_Third) key (stk_first)

When I checked Schema View, I got:

StkTable
(Stk_third, stk_first, Stk_second)
key (stk_first)

stk_first and Stk_second are correct. Stk_Third is shown as stk_third.

ajith

[amckinlay]

Ok, thanks, I’ll look into it.

You can always query the columns table to see what’s really there.

[Author]

Posts