Re: SQL*Forms List of Values Problem
From: Steven P. Muench <smuench_at_oracle.com>
Date: Mon, 11 Jul 1994 23:09:38 GMT
Message-ID: <SMUENCH.94Jul11160938_at_doh.oracle.com>
Date: Mon, 11 Jul 1994 23:09:38 GMT
Message-ID: <SMUENCH.94Jul11160938_at_doh.oracle.com>
In your LOV SQL Statement in question,
Instead of SELECT NUMBERCOLUMN, CHARCOLUMN ...
Use SELECT SUBSTR(TO_CHAR(NUMBERCOLUMN,1,4)), CHARCOLUMN...
That should do it.
-- Steve Muench Email: smuench_at_oracle.com Forms Development CIS: 73404,676 Product Manager Oracle CorporationReceived on Tue Jul 12 1994 - 01:09:38 CEST