AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

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.

Labels: ,

2 Comments:

Blogger Unknown said...

Just not sure why you would need a function when you can do it yourself.

5:20 PM  
Blogger Alex Dybenko said...

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.

12:58 PM  

Post a Comment

<< Home