[Stackoverflow] [Progress OpenEdge ABL] How to retrieve records in a database based off of data from different table

[Bazilby]

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

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

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...