Custom_SQL and Zero value

Use this board for starting discussions, asking questions, and giving advice on Web programming for the IBM i platform (and predecessors.)
Sebastian
New User
Posts: 1
Joined: Mon Oct 25, 2021 7:27 am
First Name: Sebastian
Last Name: Kraft
Company Name: Loxxess
Contact:

Custom_SQL and Zero value

Post by Sebastian »

Hello,

my first post and I hope this is the right forum.

I have a simple profound page with a custom_sql in a grid with two columns. The sql statement select two values. First is char and second numeric (9,2).

All is shown correct exact für the numeric values < 1. Here it doesnt show the leading 0. Like 0,00 -> ,00

How can I change/transform/set this to bew displayed correct?

Thank you in advance
Sebastian
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Custom_SQL and Zero value

Post by Scott Klement »

How are you formatting the output to control the leading zeros?

Are you formatting it within the SQL statement? Or are you using the "load into widgets" property and formatting it in the binding dialog? How would I create the same problem you're having?
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests