Subject Re: [IBO] Grid LookupCombo data not showing
Author David Harrison
--- In, Helen Borrie <helebor@t...> wrote:
> At 09:26 AM 25/10/2004 +0000, you wrote:
> >In a Ib_Grid I have a LookupCombo displaying a SmallInt field. I
> >edit the field to select another value. After the edit, the new
> >value does not display until I move to another record, then the
> >field reappears again. This behaviour does not happen with a
> >LookupCombo attached to a stringfield. Can anyone tell me what
> >doing wrong?
> Show us the dfm code for the two queries.
> Helen

Hi Helen

Thanks for the tip of comparing the queries in the DFM file. My
query was causing the problem:

"select id, descr from LookUpTable order by id"

I deleted the 'order by id' and set the orderingitems property
instead and, voila, all was well.

Rgds, David