Newbie Qn. LOVs and Record Groups

In article <378c692f.14147189_at_news.uk.ibm.com>, John H <johnw_horsey_at_DEL THISuk.ibm.com> writes
>I've picked up the maintenance of a Forms4.5 application, and am
>having a bit of trouble understanding how to link LOV's and RG's.
>
>Our application, for reasons I won't go in to, stores date information
>in number fields with a format of e.g. 990101 (1st January 1999) or
>1020101 (1st January 2002).
>
>I would like this to display this in the LOV as 1-Jan-99 or 1-Jan-02,
>and have been able to generate the SQL using an incantation of
>to_char(to_date(to_char(19000000+createdate),'YYYYMMDD')) which I have
>placed in the SQL query in the RG.
>
>I regenerated the RG when prompted, and changed the LOV column so that
>it now expects a character rather than a number field.
>
>When I try to execute it, I get an error saying it is unable to map
>the LOV column.
>
>Ideas? Thx, J
>
>
>
Probably simplest thing to do is delete the LOV and recreate it.

Andy

-- 
Andy Hardy. PGP key available on request
===============================================================