Hi,
I have a list_line command like:
Abonnement.Pakketbeschrijving=LIST_LINE(Abonnement.Pakket,'ORDER BY PakketOptie.Pakket.Volgnummer',':',' ','CodeAGF','OptionAmount,0.00')
I try to present the OptionAmount with two decimal digits f.i. 15.00. The resulting string contains amounts with one decimal digit, like 15.0. What should be the correct format string to get two decimal digits?
Regards,
Gijs.
LIST_LINE numeric format string
LIST_LINE numeric format string
Gijs van Ballegooijen.
the Netherlands.
AwareIM 8.4 (build 2708)
Server: Ubuntu Linux 18.04.2
Database: MariaDB
Config: Windows 2012R2
the Netherlands.
AwareIM 8.4 (build 2708)
Server: Ubuntu Linux 18.04.2
Database: MariaDB
Config: Windows 2012R2
-
- Posts: 2405
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: LIST_LINE numeric format string
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: LIST_LINE numeric format string
Hi Mark,
Thanks for your response, but this doesn't help. Using a @ sign, the attribute name is no longer recognized. I also tried leaving out the optional format specifier, but this gives the same result with only one decimal digit.
When shown on a form, the 'OptionAmount' is correctly displayed with two digits, but in the list_line function it isn't working.
Regards,
Gijs.
Thanks for your response, but this doesn't help. Using a @ sign, the attribute name is no longer recognized. I also tried leaving out the optional format specifier, but this gives the same result with only one decimal digit.
When shown on a form, the 'OptionAmount' is correctly displayed with two digits, but in the list_line function it isn't working.
Regards,
Gijs.
Gijs van Ballegooijen.
the Netherlands.
AwareIM 8.4 (build 2708)
Server: Ubuntu Linux 18.04.2
Database: MariaDB
Config: Windows 2012R2
the Netherlands.
AwareIM 8.4 (build 2708)
Server: Ubuntu Linux 18.04.2
Database: MariaDB
Config: Windows 2012R2
-
- Posts: 2405
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: LIST_LINE numeric format string
Hi Gijs,
What is the format you have of the Attribute OptionAmount in the Business Object?
What is the format you have of the Attribute OptionAmount in the Business Object?
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: LIST_LINE numeric format string
Hi Mark,
The format of OptionAmount is 0.00 (Type= Number)
Regards,
Gijs.
The format of OptionAmount is 0.00 (Type= Number)
Regards,
Gijs.
Gijs van Ballegooijen.
the Netherlands.
AwareIM 8.4 (build 2708)
Server: Ubuntu Linux 18.04.2
Database: MariaDB
Config: Windows 2012R2
the Netherlands.
AwareIM 8.4 (build 2708)
Server: Ubuntu Linux 18.04.2
Database: MariaDB
Config: Windows 2012R2
Re: LIST_LINE numeric format string
Try this:
Object.Number,#0.0
Object.Number,#0.0
Re: LIST_LINE numeric format string
Hi,
Thank you for response, but it's not a solution. Still the same effect, only one decimal digit.
Regards,
Gijs.
Thank you for response, but it's not a solution. Still the same effect, only one decimal digit.
Regards,
Gijs.
Gijs van Ballegooijen.
the Netherlands.
AwareIM 8.4 (build 2708)
Server: Ubuntu Linux 18.04.2
Database: MariaDB
Config: Windows 2012R2
the Netherlands.
AwareIM 8.4 (build 2708)
Server: Ubuntu Linux 18.04.2
Database: MariaDB
Config: Windows 2012R2
Re: LIST_LINE numeric format string
will it accept a function?
'CodeAGF',AS_STRING(OptionAmount)
instead of
'CodeAGF','OptionAmount'
if so, then you can do
AS_NUMBER(AS_STRING(OptionAmount),'#.##')
'CodeAGF',AS_STRING(OptionAmount)
instead of
'CodeAGF','OptionAmount'
if so, then you can do
AS_NUMBER(AS_STRING(OptionAmount),'#.##')
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: LIST_LINE numeric format string
I was thinking the same as Jaymer. If it won't accept, of course you could take a similar approach by creating another attribute & using Jaymer's rule to populate the new attribute.
Tom - V8.8 build 3137 - MySql / PostGres
Re: LIST_LINE numeric format string
Hi,
LIST_LINE doesn't accept functions as a parameter it seems, I get the message:
com.bas.shared.ruleparser.ParseException Invalid parameter identifying attribute name in LIST_LINE function
Thanks for your response however.
LIST_LINE doesn't accept functions as a parameter it seems, I get the message:
com.bas.shared.ruleparser.ParseException Invalid parameter identifying attribute name in LIST_LINE function
Thanks for your response however.
Gijs van Ballegooijen.
the Netherlands.
AwareIM 8.4 (build 2708)
Server: Ubuntu Linux 18.04.2
Database: MariaDB
Config: Windows 2012R2
the Netherlands.
AwareIM 8.4 (build 2708)
Server: Ubuntu Linux 18.04.2
Database: MariaDB
Config: Windows 2012R2