Delete saved queries in Runtime

[Bob Whitaker]

Does anybody know if this can be done.

Bob Whitaker

[Bob Whitaker]

RE: Delete saved queries in Runtime

Perhaps I should expand on this. We have a client who recruits people to participate in focus groups. He has a table with some 12000 records which store data in a number of fields some logical, some character and some memo. When they are looking for people who match criteria set by the client they use "query by form" to build a query and select people who they may want to invite to take part. Very often during this recruitment process they may want to run this query again and again so they save it. Once the process is complete they then want to discard that query definition as otherwise the list of saved queries gets longer and longer. It would appear there is no way including the use of xbasic to do this. This seems odd to me as I feel if you provide a way for a user to save a query via runtime you should also provide the ability to remove them. Any thoughts would be helpful.

Bob Whitaker

[JerryBrightbill]

RE: Delete saved queries in Runtime

Bob

What you are looking for is "TBL".QUERY_DETACH_ALL(). From the help file

"The "TBL".QUERY_DETACH_ALL() method detaches all temporary queries from a table"

Jerry

[Bob Whitaker]

RE: Delete saved queries in Runtime

Thanks Jerry that just deactivates any queries - what I am looking to do is to delete SAVED queries.

Presently this can only be done by right clicking in the control panel and deleting using the full version.

Bob

[Steve Andrews]

RE: Delete saved queries in Runtime

Bob,

Try the Query.Delete() method. This method does bring up a verification dialog to assure that you want the query deleted. If you want it run silently without such dialog, I don't know how to accomplish such.

Query.Delete("YourQueryName")

Steve

[G Gabriel]

RE: Delete saved queries in Runtime

Bob:
I answered a closely related question in the past. I don't fault you for not being able to dig it up if you ran a search as it's more like a needle in a hay stack.

Although I am not sure as to your reasoning for deleting a saved query (why was it saved in the first placed only to be deleted later ?? and if it was meant to be deleted later, why not create a query on the fly when needed? It's certainly a lot easier and SAFTER to create a script to run and re-run a query time and again rather than messing with the dictonary), nonetheless, here is the script:

'open the data dictionary:
t=table.open(c:\.........alpha\....ddd)
'identify saved querries
query.filter = "type='QBES'"
qry=tbl.query_create()
tbl.delete_range()
tbl.close()


Steve:
querry.delet() is not a recognizable xbasic command. Add it to the wish list or use the above script to create a UDF.

Once again, I do not see the logic of saving then deleting a saved query with xbasic, hence, I won't waste time creating a UDF that I won't use.

Gabe
P.S. I read your reasoning behind saving then deleting the query. I think you would be much better off changing your approach where you would use ONE saved query and a set of variable.

[Steve Andrews]

RE: Delete saved queries in Runtime

querry.delet() is not a recognizable xbasic command.

Gabe,

Maybe "querry.delet()" is not recognizable but I successfully deleted some saved queries via xbasic using "query.delete()".

Steve

[Bob Whitaker]

RE: Delete saved queries in Runtime

Big thank you all of you for your assistance. I think if you read my second post I outlined in detail why these queries were saved and reused over a number of days and were then discarded when the project was complete.

Query.delete("????") does work and thank you for that.

As a quick solution I have created a button that first of all brings up the "run saved query" dialogue so the user can see the names of the saved queries.

Next comes a dialogue to fill a variable (qname) with the query name and finally some xbasic :-

query.delete(var-"qname)

This does precisely what I require and I am very appreciative of your help. I plan to experiment with xdialog to populate a dialoge box with the names of the variables so the variable can be filled from there to save the name having to be typed in again.

Perhaps future versions might have a right click / delete facility in the run a saved query dialogue box.

Bob Whitaker

[G Gabriel]

RE: Delete saved queries in Runtime

Steve:
Here is what the help file says:

"The "OBJECT".DELETE() method applies to objects of type:
Browse
Form
Label
Letter
Report
The "OBJECT".DELETE() deletes the named object from disk"

As you see, query is not one of them. By the way, that was the first thing that came to mind. I tried to "cheat" the help file, but again, it didn't work for me. Don't know why !

Gabe

[Steve Andrews]

RE: Delete saved queries in Runtime

Gabe,

I'm surprised it didn't work for you when you tried to "cheat".

I agree it is not in the documentation same as some other functions and methods which do work. For instance, I have made use of the function script_drop() which is not in the documentation at all. Maybe such functions are not intended for general use but they do work and they accomplish my goals.

BTW, while the documentation is as you stated, if you type "Query." in an xbasic script the "delete()" method will appear in the drop down list of available methods.

Steve

[G Gabriel]

RE: Delete saved queries in Runtime

Steve:
Believe me, I tried all of the above before trying to mess with the dictionary! Not a chance !!

Maybe you have the "Deluxe" version! I know, I should have bought the more expensive one !!

Gabe

[Steve Andrews]

RE: Delete saved queries in Runtime

Gabe,

When you are editing a script and type in "query.", do you not see "delete()" in the drop-down list?

Steve

[G Gabriel]

RE: Delete saved queries in Runtime

No Sir I don't !!
There are only 4 options, delete is not one of them. Granted, I do not have the last built, but I doubt that's what it is!
Gabe