Possible use of Saved Query?

[scottly]

Just wondering if someone can comment on the following - is it possible?

I have an application where I want a user to be able to devise their on if/what tests based on data in one table. I figure that I can create a Form based on the table in question and they can use this with a button for the Query Geneie to create/test a Query and save the query.

When they exit the Query Genie, I want to check the saved queries for the table and add any new ones to a seperate table that contains all query names for the table and a flag used to indicate if the Query is a Test Query (default when a new Query added to this table) or a Live Query.

In a Form that is 'not related' to the table that the Queries were created for, I would need to code in a routine that, for each query flagged as Live in my special queries table, run that query against an opened instance of the related table. This is to occur without user intervention.

So I guess my questions are:

Is it possible to code a routine that will get a list of saved queries for a specified table? (from which I would then maintain my special saved queries table of info)?

Is it possible to then run a saved query based on a table that is opened in a form where the Form is not related to the table in question?.. So lets say my form is based on table A. In an ontimer routine I manually open table B, run one or more saved queries (that my user previously created and is flagged as Live in my special queries table), interogating the result of each query (number of records and associated table data).

Hope this makes sense... any direction would be much appreciated.

Regards,
Scott

[scottly]

RE: Possible use of Saved Query?

I see that saved queries only run in a form or browse that is based on that table/set of the saved query.

I can't see a way where I can give my user the flexibility to create multiple queries for a table using the Query Genie and then me to have a routine that will run and action records based on any user queries created - in a Form that is not based on the table that the query is written for - right? What I want is like batch processing of any queries that a user creates..

[Steve Andrews]

RE: Possible use of Saved Query?

Scott,

I wonder if you're not reinventing the wheels unecessarily. Do you really need a new table of query names and table names apart from the Alpha5 system?

Whatever, as for your first question you can get a list of all queries for a given table name with one expression:

tbl_nam="s_time_leave"
?filter_string_smatch(a5.Query_Enum(),"*\\"+tbl_nam+".*",crlf())
= Tardy_Test@\\server1\pers$\s_time_leave.set
Query_Tardy@\\server1\pers$\s_time_leave.set
qTardy@\\server1\pers$\s_time_leave.set

My 2 cents.

Steve

[scottly]

RE: Possible use of Saved Query?

Thanks Steve - I need my table of queries as the user will create queries - test them and flag some as live (use them in live auto processing) and others as Test (they can test them but an auto process will not run them).

But I think I can not do with a saved query what I need in part 2 - that is, can't run a saved query unless it is run in a Form/browse that is basedon the saved query.

In a manually coded query on a table, for example:

query.filer="a filter expresion"
query.order"an order expresion"
etc..

I want to make this dynamic and swap the expressions for those from one or more queries that the user has created using the genie.


Regards,
Scott

[scottly]

RE: Possible use of Saved Query?

I think I need my own 'end user expression builder' - for many reasons - like since the user should not use "Ask for value at runtime" and other options that are in the genie.

I could save the end user built expressions in to a table and then use them in a routine that would cycle through and query based on the saved expressions (substituted in to the query.filter and query.order values)..