Re: Forms4.5, preserving blanks

Try defining your required table's column as CHAR rather than VARCHAR2 otherwise the server side will truncate any spaces off your (alphanumeric) data in any case.

As a warning: if this is a required column it suggests that a data value is required - even if you put in some 'dummy' value to represent no data e.g. 'NONE'. Regards

• Martyn Cavett Senior ORACLE Analyst LGT Asset Management London, UK. home: cavett_at_globalnet.co.uk work: Martyn.Cavett_at_gtplc.com

These views are my own and not those of my employer. Normal conditions apply.

David Kao <david.kao_at_nist.gov> wrote in article <01bc5efd$49f103c0$4a540681_at_h084074.nist.gov>...
> 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?
>
>
  Received on Tue May 13 1997 - 00:00:00 CEST