News, links, downloads, tips and tricks on Microsoft Access and related
Wednesday, March 10, 2010
Functions to parse query SQL
J Street Technology offers J Street SQL Tools - a set of functions, which can parse query SQL into WHERE or ORDER BY clauses, so you can manipulate only certain part of query.
Hi, for example - you have a saved query, and want to run recordset on it, but with different where clause. so using this function you change where clause, keeping original intact.
Just not sure why you would need a function when you can do it yourself.
ReplyDeleteHi,
ReplyDeletefor example - you have a saved query, and want to run recordset on it, but with different where clause. so using this function you change where clause, keeping original intact.