Database SQL error using a between operator with a changeable parameter (Article # 255)
View products that this article applies to.
Problem:
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 ')'
Resolution:
This is a bug in Query Anything, specifically in the CB code for form 2218.
This has been fixed in qa2218.cbs
Applies To: