Results 1 to 2 of 2

Thread: SQL language problem

  1. May 6th, 2003, 04:08 AM #1
    VBJunior25
    VBJunior25 is offline

    Thread Starter
    New Member
    Join Date
    May 2003
    Posts
    1

    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 ....
    Reply With Quote Reply With Quote
  2. May 6th, 2003, 04:15 AM #2
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    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.
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width