Currency change on A5W How?

[imaddison]

Trying to change $ to � on the ASW app.

edit
productlist.a5w
inside this edit
grd_prods
fields, display format says
if(<value>=0,"",alltrim(str(<value>,25,2,"$")))

I change format to display in �, see attached print. Save and publish and it still $

Done this many times and still the same.

Can anyone guide me please

[Lenny Forziati]

Re: Currency change on ASW How?

The server's setting defines the currency symbol to be used, not the devlopment environment. You'll need to check the regional settings on your server.

If you are using AlphaFiveOnline, the regional setting is U.S. In this case, you can find some alternative methods discussed here on the message board.

[imaddison]

Re: Currency change on A5W How?

Thanks very much Lenny,

We are using AlphaFiveOnline, so will need to look up those work arounds.

Can you direct me to a specific thread(s) please?

Thanks in advance

[Steve Wood]

Re: Currency change on A5W How?

I found one solution to setting alternate currency symbols in numeric formatting. (I could not find any other on this forum).

To alter your currency symbol to British Pounds for instance, start out with the standard formatting option: alltrim(str(<value>,250,2,"$(")), then remove the dollar sign.

Then add "�" to the front of the statement so it looks like this:

"�" + alltrim(str(<value>,250,2,"("))

The only way to get the pound symbol in there* is to go to Notepad (or similar), hold down the Alt key and press 0163 on your numeric keypad. Then copy-paste that symbol into the Display Format area. You can't do that Alt+0163 directly in the Display Format area.

* I suppose places where they use the Pound have an easier time creating that symbol.

[gotobedd]

Re: Currency change on A5W How?

The � shows up in Mozilla but AOL and IE browsers don't show it

Duncan

[Steve Wood]

Re: Currency change on A5W How?

My IE browser shows the pound symbol. Maybe this is not a perfect solution, not sure where to go to make sure it is.

[rleunis]

Re: Currency change on A5W How?

So many systems I worked with have difficulties dealing with special characters, than I have changed my approach with currencies f.i. by adding a field currency code (character 3) and populating this with the ISO Currency abbreviations. So Euro's will be EUR, British Pounds will be GBP and US dollars will be USD.

I use this to print the currency code on forms and printouts like invoices, reports, etc. When using a separate table with these ISO currency codes, just add a column for the currency rate against your local currency and currency conversions is a breeze also. No problems anymore on printer also...You can use the table as a dropdown also.

And later use them easier in select statements, like select invoice_amounts from Invoices where currencycode = "GBP"..

You could even enter the special codes in this table and use the table to display on forms and reports, if you still want those.

Just a thought.

regards, Ronald