on 11-09-2007 9:51 AM
Hello, i'm working with DataTables and Grids.
I Define DataTable columns in screen painter, bind grid to datatable e fill values of datatable with SetValue Method.
I define numeric columns with decimal of ft_Float type.
The problem is the number of decimals i see in these columns: i made some test and i've discovered that it corresponds to the 'Amounts' setting of the general settings form! Always..!
I need to put quantities in these columns not amounts.
I need to see quantities with 6 decimals and amounts with 2.
How can i do it if datatable only have ft_Float to work with decimals and it only 'listens' to 'Amounts' ?
Pleas help...
I'm using SAP B1 2005A SP01 PL 36.
Thank
Paolo
Hi Paolo
i came across the same problem and the way I solved it is by manipulating the number of decimals in the query itself, something like this ...
SELECT Field1, CAST(CAST(U_Amount AS DECIMAL(10,2)) AS VARCHAR) 'U_Amount'
FROM Table1
Notice the first CAST Function returns the amount in the decimal format desired and then the second one converts it to a string. It solve my problem.
hope it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Paolo,
We had the same problem and we solved it in the query by formatting the fields and made strings of it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.