How can I save the currency symbol into DB

This forum is for eXpress++ general support.
Post Reply
Message
Author
User avatar
unixkd
Posts: 630
Joined: Thu Feb 11, 2010 1:39 pm

How can I save the currency symbol into DB

#1 Post by unixkd »

Hi all and happy weekend.

How can I save ANY currency symbol into a table in database. I notice that:

Function getcurrency()
Local getlist[0], cCurr := space(4)

@ 1,1 dcsay "enter currency symbol" get cCurr

Dcread GUI modal addbuttons

When I enter pound or some other symbol and the get get lost focus the text box change to ?

Thanks

Joe

User avatar
rdonnay
Site Admin
Posts: 4879
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: How can I save the currency symbol into DB

#2 Post by rdonnay »

I need more information. I don't see a problem.
The eXpress train is coming - and it has more cars.

User avatar
unixkd
Posts: 630
Joined: Thu Feb 11, 2010 1:39 pm

Re: How can I save the currency symbol into DB

#3 Post by unixkd »

Hi Roger

I have a setup table with 3 fields namely:

1. Currcode e.g. NGN for Nigeria naira
2. CurrName e.g Naira
3. CurrSymbol e.g N crossed with equal sign.

Now where the problem lies is the symbol. If copy the symbol from charmap.exe of windows and paste it on the dcsay.. get cVarSymbol, the text box change to ? when the text box loses focus. This problem is easy to test. Just run charmap.exe and copy even the eur currency symbol into any get object in your application then press enter key it will change to ? I think it has to do with unicode handling by Xbase++ which deal with ansi. I don't know how DBMS
like ads handle unicodes or problem like this.

Thanks

Joe

User avatar
Auge_Ohr
Posts: 1448
Joined: Wed Feb 24, 2010 3:44 pm

Re: How can I save the currency symbol into DB

#4 Post by Auge_Ohr »

hi,

which Font do you use ?
Alaska support :
Arial Arial

Arial Fett

Arial Fett Kursiv

Arial Kursiv

Arial Narrow Arial Narrow

Arial Narrow Kursiv

Arial Narrow Fett

Arial Narrow Fett Kursiv

Courier New Courier New

Courier New Fett

Courier New Fett Kursiv

Courier New Kursiv

Verdana Verdana

Verdana Fett

Verdana Kursiv

Verdana Fett Kursiv
your Sign must include in those Fonts else you Will get "?" for unknown Sign.
greetings by OHR
Jimmy

User avatar
SlavkoDam
Posts: 152
Joined: Wed Apr 27, 2022 10:12 am
Location: Negotin, Serbia
Contact:

Re: How can I save the currency symbol into DB

#5 Post by SlavkoDam »

Hi Joe,

You can try in Windows->Control panel->Region->Change system locale to Nigerian language, and enter into Get field Alt+8358 on the numeric keyboard.
Slavoljub Damnjanovic
SD-SoftDesign, Alaska Software Technology Partner
https://www.sd-softdesign.com
https://www.sd-softdesign.rs

Post Reply