devxlogo

QueryWhere()

QueryWhere()

Why Trust Us

Question:
Can I use more than one criteria in the QueryWhere(“col1=’val1′”&”col2=’val2′) to refresha bound grid? I would really appreciate an answer or a solution; we are on the border line between tossing OPO and six weeks of work in favor of PowerBuilder 5.0, Delphi or maybe VB.

Answer:
The QueryWhere() method takes a string that is the equivalent of theWHERE clause in an SQL statement. The QueryWhere() can takemultiple conditions, the same as a WHERE clause, so you should have noproblem.

The problem might be in your syntax. If you want to set the conditionwhere col1 is equal to val1 and col2 is equal to val2, you should use thesyntax

QueryWhere(“col1 = ‘val1’ AND col2 = ‘val2′”)
This will work fine.

Also, make sure you use actual strings for the values,rather than trying to access the Value property directly.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More