Re: Looking at query record selection criteria from RPG/CL

I got as far as the RTVQMQRY bit but have not created a program to rebuild
the queries. The resulting source code is easy to read though and i was able
to manually zip through and determine which queries were affected by the
account number renames. Mind dullingly boring though....

Thanks to those that replied.


"No Name" <NoName@xxxxxxxxxxx> wrote in message
news:010Ne.12031$0E5.2725@xxxxxxxxxxx
> Jaosn Hubbard wrote:
>> I have to change some queries that have certain account numbers in them -
>> problem is there are hundreds of queries and i don't know which to change
>> without manually editing each one.
>>
>> I could print the query definitions, consoildate them all into one PF and
>> read through that, but i figure there must be a slicker way??
>>
>> Is there any way i can scan through the record selection criteria for
>> each query in RPG or CL? Are there any API's for this purpose?
>>
>> regards
>> Jason
> I've never tried this but, retrieve the query source, modify and recreate:
>
> RTVQMQRY QMQRY(Lib/QryName)
> SRCFILE(*Libl/QCLSRC)
> ALWQRYDFN(*YES)
>
> Write a program to modify the retrieved source and recreate the query.
>
> Good Luck


.

Relevant Pages

  • Re: Text Box in Form vs. User-Defined Criteria
    ... try to recreate the form by renaming it and then making a copy of it with the ... the date in that text box and pull the date from there in my query as ... took only 20 seconds to run with the date entered in the pop-up. ... queries on the same form have this problem but I don't have this ...
    (microsoft.public.access.queries)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: "Query Too Complex" Errors
    ... few dozens of queries, in the middle of which there's a long chain of ... we've been having a lot of those "Query Too ... some of the complexity in the SQL ... SQL statement you are working on. ...
    (microsoft.public.access.forms)