NeoSoft Support Forum

[carlos torres]

Hi everybody

I'm trying to upgrade an old app developed with dbf to dbp.

When I use this statement with integer values it works fine

[Wrangler]

I have a similar problem with a currency field in Access db:

../ Get total item sales per model
FileLen "[pubdir]products.dat" "[flen]"

Loop "1" "[flen]" "[x]"
FileRead "[pubdir]products.dat" "[x]" "[getproduct]"
dbpQuery "invoicer" "products" "proddesc = [#34][getproduct][#34]"
dbpSum "invoicer" "products" "subtotal" "[total[getproduct]]"
dbpSum "invoicer" "products" "qty" "[[getproduct]sales]"
Math "[totalitems]+[[getproduct]sales]" "" "[totalitems]"
endloop

Brings this result:



It only does it to a couple of them. All the rest display correctly. Don't know if this is related to Carlos problem or not.
_________________
Wrangler
--------------
Before you criticize someone, walk a mile in their shoes. Then when you criticize them you're a mile away and you have their shoes. - Wrangler

Software made with NeoBook
http://highdesertsoftware.com

[Neosoft Support]

What you need to do is use DBPro's dbpSetFieldProperties action to define the DisplayFormat for the field. This will allow you to customize the number of decimal places, etc.
_________________
NeoSoft Support

[Wrangler]

I'm using a currency field. Shouldn't it default to 2 decimal places?
_________________
Wrangler
--------------
Before you criticize someone, walk a mile in their shoes. Then when you criticize them you're a mile away and you have their shoes. - Wrangler

Software made with NeoBook
http://highdesertsoftware.com

[Neosoft Support]

Wrangler, I think the problem with your numbers is caused by the Math action. In your example, you left the second parameter empty which causes the result to have as many or as few decimal places as it needs. Instead, if you want the result to have exactly two decimal places, you should put "2" in this parameter. For example:

Math "[totalitems]+[[getproduct]sales]" "2" "[totalitems]"
_________________
NeoSoft Support

[Wrangler]

The math action totals the number of items, which isn't affected by this. However, I fixed it by adding a math action after the dbpsum:

../ Get total item sales per model
FileLen "[pubdir]products.dat" "[flen]"

Loop "1" "[flen]" "[x]"
FileRead "[pubdir]products.dat" "[x]" "[getproduct]"
dbpQuery "invoicer" "products" "proddesc = [#34][getproduct][#34]"
dbpSum "invoicer" "products" "subtotal" "[total[getproduct]]"
Math "[total[getproduct]]" "2" "[total[getproduct]]"
dbpSum "invoicer" "products" "qty" "[[getproduct]sales]"
Math "[totalitems]+[[getproduct]sales]" "2" "[totalitems]"

endloop

I guess I assumed because I set the field properties for the subtotal field to currency in startup actions:

dbpSetFieldProperties "invoicer" "products" "subtotal" "Alignment=Center;DisplayFormat=#.00"

it would also display as such after the dbpsum. Funny thing is, it did it for all of them but the two.
_________________
Wrangler
--------------
Before you criticize someone, walk a mile in their shoes. Then when you criticize them you're a mile away and you have their shoes. - Wrangler

Software made with NeoBook
http://highdesertsoftware.com

[Neosoft Support]

dbpSum works outside the constraints of the table, but I suppose it could borrow the field's display format for its result. However, what if the display format includes something that isn't normally part of a number such as a dollar sign? That could mess up any subsequent math actions. For example:

DisplayFormat=$#.00

or

DisplayFormat=£#.00
_________________
NeoSoft Support

[Wrangler]

You have a point there. If the $ is included in the field data, it wouldn't work. But it's not stored in there, is it? Can't see how it could sum it up if it was.
_________________
Wrangler
--------------
Before you criticize someone, walk a mile in their shoes. Then when you criticize them you're a mile away and you have their shoes. - Wrangler

Software made with NeoBook
http://highdesertsoftware.com

[domino]

I`m having a similar issue with my application

In effect I`ve created a shopping cart and whether I use math or dbprosum I can`t get it to display .00 where a value has no decimal places.. (ie whole £ pounds no pence)

eg: it displays 24 rather than 24.00

(in math mode setting decimal places to either 2 or -1 has no effect.)

[dpayer]

[domino]

[David de Argentina]

Or...

Use NeoFormatNumber Plugin in order to do a specific format.

You could check this plugin at:

http://www.neosoftware.com/neobook/modules/plugins/singlefile.php?cid=9&lid=54

Greetings from Buenos Aires,
David de Argentina

[Wrangler]

For me, the math method works if used right before display or after the sum:

Math "[total]" "2" "[total]"
_________________
Wrangler
--------------
Before you criticize someone, walk a mile in their shoes. Then when you criticize them you're a mile away and you have their shoes. - Wrangler

Software made with NeoBook
http://highdesertsoftware.com

[domino]

Thanks for the replies....

Unfortunately none of them quite deal with the main issue which appears to be the inability of a "currency field" to retain the .00 for whole numbers.

Any of your solutions are fine as workarounds - but mean that the dbpro sum command cannot be used 'as is' if the .00 is required.

For my application it's not a huge issue as I simply reformatted the relevant fields as strings and ran math loops thus enabling the offending .00 results to carry through to the preview, report and the completed orders table.

Cheers
Dave

[Neosoft Support]

The following was added to DBPro 1.2 released in January: