Author Topic: GRIM input  (Read 4997 times)

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
GRIM input
« on: May 02, 2012, 03:42:52 PM »
Using the GRIM interface I am trying to allow the user to enter upper or lower case and to select the same word from the field in upper or lower case.

I figure how to select items of upper or lower case but only if the user makes an entry in Upper case.

Any suggestions to allowing them to enter the prompt in upper or lower case?

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
Re: GRIM input
« Reply #1 on: May 02, 2012, 05:17:00 PM »
Here is a backwards way of doing it... but it works.

To get the input of all upper case to select data (no matter what case it was) I created a dictionary item with a derived field that included a conversion to upper case.
For example to get DICT ORDER ST.NAME
I created ST.NAME.UPPER with derived field    (F("ORDER",CO.NUM:ORD.NUM)<4>)"MCU"

so why not create one for lower case and title case...
ST.NAME.LOWER
ST.NAME.TITLE

then in the selection statement test for the upper OR lower OR title case.
Okay it a bit cluttered but it works.

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
Re: GRIM input
« Reply #2 on: May 02, 2012, 05:34:53 PM »
Everything I've done adjusts the items I've selected and not the value I entered.
I could still use a method to do that.
For example... if someone type in CHarlotte   instead of  charlotte, Charlotte, or CHARLOTTE  it would not be found.

Tom Pellitieri

  • Rock Star
  • *****
  • Posts: 224
  • Tom Pellitieri - Toledo, Ohio
Re: GRIM input
« Reply #3 on: May 03, 2012, 07:33:12 AM »
You only need ST.NAME.UPPER.  In the GRIM screen, use MCU as your input conversion under the "Cnv" column.  That will force the input to upper case, which should compare properly.