Aligning number fileds in Oracle Forms Builder
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Aligning number fileds in Oracle Forms Builder

  1. #1
    Join Date
    Dec 2004
    Posts
    8

    Aligning number fileds in Oracle Forms Builder

    Dear All,

    In Form Builder, while displaying in the LOVs, how can I align the number fields? The number fileds aligned looks like the example given under:
    Code Desc Amount Optr

    5 AAA 4,55,265.56 DFLT
    7 BBB 0.00 DFLT
    9 CCC 3,05,123.75 DFLT
    11 DDD 0.00 DFLT

    How do I make the zeroes as well as the number fields with values right justified?

    regards
    sreeranjini

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021

    Re: Aligning number fileds in Oracle Forms Builder

    Originally posted by ranjini
    Dear All,

    In Form Builder, while displaying in the LOVs, how can I align the number fields? The number fileds aligned looks like the example given under:
    Code:
    Code Desc      Amount      Optr
    
     5   AAA    4,555,265.56   DFLT
     7   BBB            0.00   DFLT
     9   CCC    3,505,123.75   DFLT
    11   DDD            0.00   DFLT
    How do I make the zeroes as well as the number fields with values right justified?

    regards
    Conver the numbers to text using an TO_CHAR and LPAD.
    LPAD(TO_CHAR(Amount, '99,999,999.99'), 15)
    this space intentionally left blank

  3. #3
    Join Date
    Dec 2004
    Posts
    8
    Dear All,

    The conversion method mentioned above, was also tried before and it gave me the alignment as

    Amount
    4,55,658.90
    0.00
    22,565.80

    etc like this. The alignment mentioned in my first thread was after converting the number field with the conversion that was mentioned in the reply. Is there some other way, which will align the number fields? This lpad(to_char(amt,FM)) works fine in the SQL prompt, with the correct alignment. But it doesnt work fine with the Form Builder.

    regards
    ranjini
    sreeranjini

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width