[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Newbie questions about dynamic query preparation in ABL

[dbeavon]

@jon That is helpful. I wonder why the dynamic queries will allow us to use the temp table from the local session, but not the local memory variables. It seems to be a bit of an inconsistency. I like the fact that, if you can structure the query this way, then this will allow us to do the QUERY-PREPARE (the compilation) just one time and reuse the compiled query. I assume I can even close and reopen the query without repeating the QUERY-PREPARE operation. As you point out, it looks like I can use the ttTest to hold any necessary arguments for the rest of the query. It would still be nice if parameters could be sent to the query without having to go thru an intermediate temp table.

Continue reading...