Subject Re: [IBO] Newbie and Master-Detail
Author Jason Wharton
> The problem is: The user requires that the MasterLink field , which is
> ACCOUNT always be displayed in UPPER case. And the actual database field
> is in *lower* case. It is very convenient to use the CharCase Field
> Property to UPPER case it for display.
>
> But if I do that, the MasterLink Param is also passed in UPPER case rather
> than in the *actual* case of the field in the database. And therefore, no
> matches.

That is a strange case indeed.

Perhaps you could leave the data as-is and use the capabilities of the
grid's OnGetCellText to manipulate the presentation of the data to uppercase
in the grid only.

If you do this, the TIB_Grid is a little unusual in how it resolves to data.
It isn't as easy as it is with the TDBGrid in that you can directly access
the TFields of the linked dataset.

See the Contact sample application to see how I manipulate colors of cells.
You will need to follow that pattern somewhat.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com