Can not format number as string in V7

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
BLOMASKY
Posts: 1476
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Can not format number as string in V7

Post by BLOMASKY »

I have a money field with 2 decimals. It will display fine in a grid, but I need to change it to a string and append something to it. I have tried

BO.strField = BO.price
BO.strField = AS_STRING(BO.price)
BO.strField = AS_STRING(BO.price, '#,##0.00')

And I always get the amount with NO commas and 1 decimal place.

Any suggestions please?

Bruce
BenHayat
Posts: 2749
Joined: Thu Dec 23, 2010 5:48 am
Location: Fla, USA
Contact:

Re: Can not format number as string in V7

Post by BenHayat »

Does this work in V6? If yes, I'd report it t o Support.
BLOMASKY
Posts: 1476
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Can not format number as string in V7

Post by BLOMASKY »

Ben, I don't have no STINKIN V6 on my computer any more! I am up with the times, down with the latest version.

(But it would be really easy for our friends down under to determine for them selfs, if this the correct behavior)

Bruce
BenHayat
Posts: 2749
Joined: Thu Dec 23, 2010 5:48 am
Location: Fla, USA
Contact:

Re: Can not format number as string in V7

Post by BenHayat »

I have to have V6 all the time to "Verify" V7's behavior. I know my V6 app version worked as it was designed, but during conversion and testing, it's essential to run them side by side for behavioral verification.
BLOMASKY
Posts: 1476
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Can not format number as string in V7

Post by BLOMASKY »

GOOD, then we have a plan Ben!

When I find something that is working wonky in V7

you will "run them side by side for behavioral verification"

Then someone will do a behavioral modifcation to me! and my wife will thank them profusely!

PERFECT

Bruce
Jaymer
Posts: 2475
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Can not format number as string in V7

Post by Jaymer »

SAME 'OL BRUCE !!!

hey man!
BLOMASKY wrote:Then someone will do a behavioral modifcation to me! and my wife will thank them profusely!
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
Post Reply