- This topic has 3 replies, 2 voices, and was last updated 10 years, 6 months ago by .
Viewing 4 posts - 1 through 4 (of 4 total)
Viewing 4 posts - 1 through 4 (of 4 total)
- You must be logged in to reply to this topic.
Integrated Application Platform
Integrated Application Platform › Forums › General › ? Bug in key – lower
Executing
create testable (testcol) key lower (testcol)
in QueryView shows an error query: synatx error create testable (testcol) key @ lower (testcol).
If i remove lower, it works fine. Is there an error in what I have typed or is it a bug?
ajith
Hi Ajith,
I have removed support for “lower” indexes since they weren’t fully implemented.
My plan is to allow indexing a rule (which could do lower). This has the advantage that you have a way to access the original field(s) as well as the transformed field. One issue is that if you modify the code of the rule, then the index has to be rebuilt, but this is hard to detect automatically.
Hi Andrew,
Thanks for the reply. Indexes should be fine with a rule. If I want people to restrict entry in a key field to only one case, I should use a control rule to check the case?
ajith
Yes, you can handle it in the user interface.