Re: LOV: Truncating columns to 30 characters

Dear Michael,

         This looks like an Oracle Developer design limit. There are warnings, and NO, they should not have any such limits, and YES, the programmer should always be able to override them.

         You can mitigate the problem by removing the spaces and listing the names beside each other:

Smith, John Q. Mr.

e.g. initcap(rtrim(ltrim(person.lastname))||', '

                        ||ltrim(person.firstname)) fullname

would be put in the record group query for the list. With that setup, most names show completely, and only the longest might lost a few characters.

Good luck,
Mike Rainville
Montreal, QC, Canada

Michael Ringbo wrote:

> Hi All
>
> Somebody must have seen this before (I hope).
>
> I am generating Forms (v. 5.0.6.0.8) using Designer/2000 (v.
> 2.0.19.0.3).
>
> The problem:
>
> LOV's based on columns in databasetables are truncating all of the shown
> columns to 30 characters!
>
> This can be seen in the associated record groups property "Column
> specifications".
>
> It's VERY annoying when the LOV's are used to show for example peoples
> names, or other columns which ar typically over 30 characters wide.
>
> Note: The problem can't be handled through the "display width" property
> in Design Editor: All columns are always 30 characters.
>
> Is there a workaround?
> Have I missed something?
> Or is it "just-another-bug"?
>
> Thanks in advance
>
> Michael Ringbo
Received on Tue Mar 16 1999 - 21:28:32 CET