Results 1 to 2 of 2

Thread: Ado Ce

  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Unanswered: Ado Ce

    Using Embedded VB to retreive data from an access database in WinCE I found that ADO CE does not support the BETWEEN clause.

    strSQLSelect = "SELECT * From MAXTOW_ECSOFF_FLAPS10 WHERE Temperature BETWEEN " & MyTemperature - 4 & " And " & MyTemperature + 4 & ""

    How can I manipulate this statement to retreive my data if Between does not work. Stumped.

    Thanks for you help.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What is between really doing?

    If a temperature is between mytemperature -4 and mytemperature +4, then by definition it is > MyTemperature - 4 and <= MyTemperature + 4. So use that instead...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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