-
SQL language problem
Hi All ,
so , our IT team have created a VB - SQL Server project
Everything works fine ,
but
we have worked with the Resource Editor
so we can make this project work in 4 different languages .
(It depends on the regional settings of the pc)
Anyways ...
We have a little problem with an SQL Statement ,
when we set our regional Settings in DUTCH
then
the SQL statements uses 'WAAR' in stead of the english term
'TRUE' in a BOOLEAN .
=> Program crashes !!!!!!!!!
How is this possible?
Isn't the SQL Statement universal?
I really don't know why it changes the statement
= TRUE into the DUTCH version
Btw , we use Visual Basic 6 , SP 5 , SQL Server
=> All of them are English versions ....
-
Strange things happen. Even over here.
I've seen this on Access too. When you got a field with Yes No it changes in Ja Nee.
The only workaround i found is not to use the words but the values . 0 = false <> 0 = True
It is better to use <> 0 then 1 , cause access wants to use -1.