Date Formatting - Again!

[ChrisO]

Thanks for testing that, Smig.

So it seems as if the conversion to Hebrew does not happen just because the Boolean is inserted into a string but because of the formatting applied to the Field which in this case would be Field ‘SomeBoolean’.

I’ve attached a small demo with a table containing a Field formatted to Yes/No.

If you don’t mind can you please test it again with the Hebrew language pack?
I’m trying to figure out if the Hebrew language pack reformats the Yes/No to Hebrew and then might cause the SQL to crash.

Thanks again,
Chris.

 

[ChrisO]

BTW, sorry about the time at your end, I didn’t check what it would be.

Sorry about that,
Chris.

 

[Galaxiom]

Period and Full Stop is like And and Ampersand.

Isn't the full-stop, stop or period now known as the "dot"?

I say it in jest but I some a convergence likely. We do tend to ultimately adopt the most easily said and unamibguous version of a word and dot is up there with the rise of dot com.

The fundamental difference between meaning a mark to separate objects (in between sentences), and a mark to to define a relationship between two objects might prevent the merger.

The URL structure is quite like the object structure familiar to programmers but now part of main stream langage. The concept of the dot meaning a relationship is on the rise.

 

[RainLover]

Isn't the full-stop, stop or period now known as the "dot"?

It could also be know as a Decimal Point, or simply a Point.

I won't go on for fear of hijacking a very good Discussion on Dates if you get my point.

 

[gray]

And, of course, the nomenclature of (probably) most prolific use of that symbol in history, gave it the name "dit".... coined by a certain American, Mr Morse. As in dit-dit-dit-dah-dah-dah-dit-dit-dit.... my example, appropriately enough, being SOS!

 

[smig]

Thanks for testing that, Smig.

So it seems as if the conversion to Hebrew does not happen just because the Boolean is inserted into a string but because of the formatting applied to the Field which in this case would be Field ‘SomeBoolean’.

I’ve attached a small demo with a table containing a Field formatted to Yes/No.

If you don’t mind can you please test it again with the Hebrew language pack?
I’m trying to figure out if the Hebrew language pack reformats the Yes/No to Hebrew and then might cause the SQL to crash.

Thanks again,
Chris.

I tested it under the English user interface (what I nomaly use) and had no problems.

I can't load the Hebrew user interface disc (Either CD or the DVD-RW is bad)
I'll test it when I get back to work, next week, after the passover vecation.

BTW - don't worry about the times

 

[ChrisO]

Thanks, Smig.

I read today the language packs are no longer available for 2003 or 2007.
There is one available for 2010 but apparently it doesn’t work for previous versions.

Have a good holiday,
Chris.

 

[smig]

an update:
I managed to install the Hebrew user interface.
I had no problem with the code after changing the interface to Hebrew.

Only problem is seting a default value when field format is set to Yes/No. This caused the default value to change to the Hebrew translation of Yes/No.
Trying to use the Hebrew translation for the True/False or Active/NonActive will not work