Re: Forms4.5, preserving blanks

David Kao wrote:
>
> I am developing a forms module to maintain a simple table, One of the
> column is REQUIRED and I like to enter SPACEs into this column, but Forms
> always consider the SPACEs I entered as NULL. Is there anyway I can tell
> Forms NOT TO RTRIM data items?

I dont know if you can do this - and I would not put spaces in the field use N/A or something else.
The problem with spaces - how many spaces are there you cannot see them to count them, Ive had lots of problems where trailing spaces have magically attached themselves to data, it really messes up the query.  where col = 'abc ' or where col = :variable If the column is required then something visable must be put in or the column is not really required

-- 
Daryl Collins                          dcollins_at_csac.com
Computer Systems Authority  http://www.csac.com