[WD19] DatetoString in a stored procedure - nation()

Startbeitrag von Michael Drechsel am 30.03.2015 10:42

Hi,

I use datetostring(....,"MMMM YYYYY") to create the name of the month in a stored procedure,
I use nation(nationgerman) to set the language to german.

Both is allowed in SP. But the names of the month still are in english ?

Any ideas ?

Antworten:

Hi Michael

By Default, WD "knows" English for the US version and French for the French version. Any information in any other language HAS to come from YOU...

In the case of the name of the month, I think that you can change them in the project settings, in the language>date part...

If THAT doesn't work, then it means it's part of one of the DLL, and has to be changed with wdInt

Best regards

von Fabrice Harari - am 30.03.2015 11:30
Hi Fabrice,

that could not be because my desktop application knows the german month names (I don´t put them in)


Its the same project, the same analysis and (in the test case) the same computer ...

von Michael Drechsel - am 30.03.2015 11:39
Hi Michael

hmmmm...

Now I'm wondering...

1. In your project, you have the german language set up, which means that the settings I was talking about for dates are set (names of the month, etc)

2. Now, everything that is global to the project is stored in the wdp file

3. I doubt that your stored procedure include the content of the wdp file...

So you should ask pcsoft about it, because it looks like a catch 22 to me

Best regards

von Fabrice Harari - am 30.03.2015 12:40
Ok,

I will do this (but I am afraid that I am number one on the pc-soft-black-user-list). :joke:

regards

von Michael Drechsel - am 30.03.2015 12:47
Hi Michel

Maybe try this:

DateToMonthInAlpha(Dagboekmutaties.Datum) this geves you the name of the month of a certain date. It takes the language of your project

regards

Allard

von Allard - am 30.03.2015 13:33
Hi,

unfortunately its the same like in datetostring() .....

von Michael Drechsel - am 30.03.2015 18:24
Michael

Not sure the below link could be a help or not:

http://help.windev.com/en-US/?3054012

HTH

King

von kingdr - am 30.03.2015 21:36
Hi King,

mhh, that looks like a way to include own *.wdm files with specific language attributes like errror messages.
In my case I need the access to (built-in) german month names or (like in the project settings configured) the system settings from the OS.

von Michael Drechsel - am 31.03.2015 08:27
Hi Michael,

You can code something quick and dirty that will do the job or overload the DateToString function with additional parameters (language) and code something like this:
SWITCH pNation
CASE German:
...(replace(replace(replace(replace(WL.DateToString(....,"MMMM YYYYY"),"January","Januar"),"February","Februar"),"March","Marz"),...)
OTHER CASE:
...
END

Recently I also had a similar call with support about:
ChangeSeparator(sepDECIMAL,".") and ChangeSeparator(sepTHOUSAND,".")
for an international webdev app of us...
Unfortunately after having changed the separators by calling the above standard WL functions, NumToString() wouldn't take these separators into account...
Reply from PCSoft: works as designed, so we had to overload the standard NumToString function...

Greetz,

Peter

von Peter Holemans - am 01.04.2015 08:11
Hi Pete,

yes, in my case PC soft also wrote that language functions in stored procedures are not supported, so I came to the same solutions as your.

von Michael Drechsel - am 01.04.2015 12:56
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.