Re: SQL*Forms List of Values Problem

rjscho_at_skcla.monsanto.com wrote:
> I want to display a list of values for an input field. The list of values
> would contain an integer code and a text string.
 

> My problem is that the integer wants to display about 40 columns
> wide. How do I limit the display to say 4 columns wide?

Wrap the number column in a substr. As in: SELECT substr(int, 1, 4), string
INTO :field1, :field2
FROM table

NB: the parameters on substr may be slightly out, because of the leading space, but you get the idea.

Why not make the column definition in the database NUMBER(4, 0)? In which case the LOV will work correctly anyway.

--
  _________________________   _______________________________
 /  Tommy Wareing          \ /                               \
|  p0070621_at_brookes.ac.uk   X  'Blobby, blobby, blobby!'      |
 \  0865-483389            / \    said Mr. Blobby            /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~