Sql Question

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Joel

    Sql Question


    I'm scrolling by Order_# where I find and display on screen the < (lesser
    then) value of Order_#. Here's the syntax:

    "Select * From Orarchd Where `Order_#` < " & lngOrderNumber & " Order By
    `Order_#` Desc"

    lngOrderNumber is the current value of Order_#. Here's the problem: It
    takes forever to find the next record (at least 10 seconds)

    PS The Db is MySql




Working...