Browsing Solutions For QUERY

  • Database SQL error using a between operator with a changeable parameter

    Create a new query that uses a changeable betwen operator. For example, I setup a new query for cases where the creation_time was between 1/1/2007, 12/31/2007. If that clause is not changeable, then the query works fine. If that clause is marked as changeable, then the resulting SQL is incorrect. For example, the user may get an error such as: Database Error: Line 1 : Incorrect syntax near ')'