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

[Brian K. Maher]

David, When building your query-prepare string I recommend that you say howdy to your new best friend, the SUBSTITUTE function, as it makes it much easier to be sure that the resulting string is what you expect it to be. For example... def var queryString as char no-undo. // annoying and error prone particularly when mixing single and double quotes queryString = “for each “ + hBuffer:name + “ where charField = ‘” + someCharData + “’”. someDynQuery:query-prepare(queryString). // much better, makes it obvious where sing/double quotes go queryString = substitute(“for each &1 where charField = ‘&2’”, hBuffer:name, someCharData). someDynQuery:query-prepare(queryString). Brian Maher Principal Engineer, Technical Support Progress 14 Oak Park | Bedford, MA 01730 | USA phone +1 781 280 3075 www.progress.com

Continue reading...