B
Bazilby
Guest
I have a query that retrieves data from "table1" that needs to be filtered by a "field1" in "table2" that is equal to data entered in the GUI.
I thought it might be
and what I thought should be the string that gets added to the query based off of criteria
When I run this I get the error.
I read that this might be a case for using a "Dynamic Query", but I haven' quite figured that out yet.
Continue reading...
I thought it might be
Code:
qryStr = "FOR EACH table1 NO-LOCK WHERE table1.deleted = FALSE " + addQryStr.
and what I thought should be the string that gets added to the query based off of criteria
Code:
IF field1 <> "" THEN
addQryStr = addQryStr + ", EACH table2 NO-LOCK WHERE table1.customer = table2.customer AND table2.salesperson = '" field1 "' ".
When I run this I get the error.
cannot run GET methods on query until it is opened. (7313)
I read that this might be a case for using a "Dynamic Query", but I haven' quite figured that out yet.
Continue reading...