-
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
-
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)
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|