Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

How to delete a custom query

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    How to delete a custom query

    I can save a query, recall it but how does one REMOVE a query. Thanks to Cal!!!!

    There is a limit as to how many queries can be saved per data file & the oldest gets deleted if you exced the limit. How be a pain if you have an old query that took you an hour to make & it got deleted because it was the oldest. Is that correct?

    To me, the custom query process management tools are VERY weak to be kind.

    dewayne

    #2
    Re: How to delete a custom query

    dewayne,

    It's not clear what you are struggling with.

    To delete a saved query operation go to the operations tab of the control panel and right click on it. Piece of cake.

    There's no limit to the number of query "operations" you can save to the operations tab of the control panel. Perhaps you need to learn how to save a query operation. Is this the problem?

    Alpha Five has a limit on the number of unsaved temporary query lists that are maintained internally. Considering the fact that these lists are static and do not get updated with changes the user makes to the data how many more would you want Alpha to keep track of for you when a single edit to a single record may render them all invalid.

    I recommend you revisit the Users Guide. The chapter on sorting and selecting records has a good topic on queries.

    Comment


      #3
      Re: How to delete a custom query

      Morning. My mistake post done before brain in gear & not enuf detail on my part.

      I can & know how to delete a Query as I have a full version of A5V8 but what I "should have" said is how does a user with only the Runtime version (V5V8) delete a custom Query he made & saved. That is our prob.

      Thanks for the reply.....

      DeWayne

      Originally posted by Tom Cone Jr View Post
      dewayne,

      It's not clear what you are struggling with.

      To delete a saved query operation go to the operations tab of the control panel and right click on it. Piece of cake.

      There's no limit to the number of query "operations" you can save to the operations tab of the control panel. Perhaps you need to learn how to save a query operation. Is this the problem?

      Alpha Five has a limit on the number of unsaved temporary query lists that are maintained internally. Considering the fact that these lists are static and do not get updated with changes the user makes to the data how many more would you want Alpha to keep track of for you when a single edit to a single record may render them all invalid.

      I recommend you revisit the Users Guide. The chapter on sorting and selecting records has a good topic on queries.

      Comment


        #4
        Re: How to delete a custom query

        Good morning.

        I didn't realize that a runtime user could create and save a custom query. Can you walk me through the steps so I can understand the scenario more fully? I guess I'm still not sure what you mean by a "custom query". -- tom

        Comment


          #5
          Re: How to delete a custom query

          I can only guess that dewayne is talking about queries that are created on the fly by users with query by form, key, index, etc. This is the only place that I am aware of where there are limitations. With this 'guess'

          dewayne,

          If your users are creating complex queries that need to be used on a regular basis, may I suggest that you create a query operation for them and allow them to run that script whenever they need it via a specific query button. This way you do not have to worry about the query being deleted.

          If my 'guess' is off the wall, you need to be much more specific with the problems. Where are you users in the runtime when they are creating the queries in the first place? Exactly what steps are they taking to create this query? Provide us with a zipped up sample of the db and give us exact steps to duplicate the query creation. Then tell us 'how' you know their query has been deleted.

          The 'devil is in the details'. I do not remember how many threads I have read that it .... but if you do not give us enough samples and step by step instructions to duplicate the problem .... we are all only guessing at what the actual problem is .... hence, our solutions are only guesses as well. It saves everybody a lot of time when details and samples are provided.
          Cheryl
          #1 Designs By Pagecrazy
          http://pagecrazy.com/

          Comment


            #6
            Re: How to delete a custom query

            Tom, Cheryl,

            This sounds so much like a previous thread I read in which Tom took part in quite a while ago.

            http://msgboard.alphasoftware.com/al...ight=statusbar

            Regardless, I guess it is possible to Save a query produced with Query by Genie, Query by Expression, etc. And apparently this can be done in a runtime situation as well--good to know! They can be brought back with the Query-->Run Saved Query menu selection. It looks like they should be able to be deleted by selecting the yellow Select Index/Query icon toward the right side of the toolbar....but it is grayed out. Once I finally figured out what DeWayne wanted (I think!) it took just a few minutes to find. You two did the hard work of "20" questions/guesses!

            If the control panel is accessible then the saved queries can be deleted from the Operations tab.

            But if this is the case then an unlimited amount of queries can be saved---maybe DeWayne is talking about the saved filters which most likely do have a limited amount. Which can be deleted easily by choosing menu item Query-->Select Index/Query or the same named icon on the right side of the toolbar. But the saved filters need not be saved (or deleted) as it is the saved queries that generate them anyway........

            The way to delete an operation would be to use

            object_operation("query","queryOperationName","","delete")


            Now I suppose we better wait to see if I guessed correctly! :)
            Last edited by MikeC; 11-17-2007, 04:17 AM.
            Mike
            __________________________________________
            It is only when we forget all our learning that we begin to know.
            It's not what you look at that matters, it's what you see.
            Henry David Thoreau
            __________________________________________



            Comment


              #7
              Re: How to delete a custom query

              I am not a programmer so plse bare with me. Ad hoc to moi means made on the fly, used once & NOT saved. A custom query is one that a user gives a name to, saves, recall so it can be APPLIED to a report.

              These NON-programmer users could spend a considreable time to prepare an elaborate query. Needless to say, sometime in the future they would like to enjoy the fruits of their labour & use the query again.

              These Queries are developed by each user for their specific use, they are NOT generic.

              Cheryl, you mention a "specific query button". Would this button allow saving, naming & deletion of any saved queries that mite not be needed?

              There is no problem with developing, naming & saving of "custom" queries so the steps are not an issue. The only prob is how would a user with only a RUNTIME delete one of these queries.

              Please fire away for more details & I will try to fill in any gaps.

              Thanks....you Folks are Champions!

              dewayne

              Originally posted by Cheryl Lemire View Post
              I can only guess that dewayne is talking about queries that are created on the fly by users with query by form, key, index, etc. This is the only place that I am aware of where there are limitations. With this 'guess'

              dewayne,

              If your users are creating complex queries that need to be used on a regular basis, may I suggest that you create a query operation for them and allow them to run that script whenever they need it via a specific query button. This way you do not have to worry about the query being deleted.

              If my 'guess' is off the wall, you need to be much more specific with the problems. Where are you users in the runtime when they are creating the queries in the first place? Exactly what steps are they taking to create this query? Provide us with a zipped up sample of the db and give us exact steps to duplicate the query creation. Then tell us 'how' you know their query has been deleted.

              The 'devil is in the details'. I do not remember how many threads I have read that it .... but if you do not give us enough samples and step by step instructions to duplicate the problem .... we are all only guessing at what the actual problem is .... hence, our solutions are only guesses as well. It saves everybody a lot of time when details and samples are provided.

              Comment


                #8
                Re: How to delete a custom query

                Dewayne, here's my confusion. I open the runtime. I load AlphaSports. I close the main menu and arrive at the control panel. From here I want to define and save a query operation. I can't. The runtime doesn't permit me to create a "new" query operation. I'm forced to conclude you're not talking about saved query operations.

                So then I open a form and use query by form to define and run a query. Works fine. But there's no option available to "save" my new custom query. So you're not talking about this, either.

                What am I missing? Can you describe for us the steps the runtime user would go through to define and save the kind of query you want to be able to delete?

                -- tom

                Comment


                  #9
                  Re: How to delete a custom query

                  Tom.

                  In runtime (I used a version 5 runtime version of my current App), Open a form or browse, go to the top menu and choose Query-->Query Genie.

                  Choose some filter criteria that suits the form/browse. Now choose the save icon on the bottom of the filter genie and save the query. This query will now be one of the saved queries that are under the Operations tab of the control panel (along with any saved queries created during development).

                  The only way I can see to delete such a saved query would be to use the function I showed in the prior post

                  object_operation("query","queryOperationName","","delete")


                  But the question remains--Is there not a very high number of these that can be saved in the operations area?? So DeWayne must be referring to something else such as the filters that are produced by these queries...maybe these only reach a certain number and then the earliest deleted??? Which is really nothing to be concerned about seeing as how these filters are only produced when a query is run.

                  DeWayne still has not answered all the questions asked so I am at a loss as to whether what I stated here and before is correct or .....
                  Mike
                  __________________________________________
                  It is only when we forget all our learning that we begin to know.
                  It's not what you look at that matters, it's what you see.
                  Henry David Thoreau
                  __________________________________________



                  Comment


                    #10
                    Re: How to delete a custom query

                    I will go thru the process if I have got your ? right:
                    1.open the Work module (its Form is based on WORK.SET)
                    2.Clicks Query Genie icon. Sets some conditions & filters
                    3.Saves the Query as "PM WORK"
                    4.at end of month goes to a report called "Work for Month" which is based on WORK.SET. Selects "Records selected by saved query". Goes to the Query above & presto the report comes out how he expects with only records based on the previously designed & saved query.

                    I had a look at Operations & of course, there is a query called "PM WORK" as expected.

                    Works very well, other than how does a user, delete this query at a later time.

                    dewayne

                    Originally posted by Tom Cone Jr View Post
                    Dewayne, here's my confusion. I open the runtime. I load AlphaSports. I close the main menu and arrive at the control panel. From here I want to define and save a query operation. I can't. The runtime doesn't permit me to create a "new" query operation. I'm forced to conclude you're not talking about saved query operations.

                    So then I open a form and use query by form to define and run a query. Works fine. But there's no option available to "save" my new custom query. So you're not talking about this, either.

                    What am I missing? Can you describe for us the steps the runtime user would go through to define and save the kind of query you want to be able to delete?

                    -- tom

                    Comment


                      #11
                      Re: How to delete a custom query

                      Good day.

                      I am unsure whether you are addressing your remarks to Tom or myself? Which ? or ?'s am I supposed to answer or did not?

                      You descibe exactly what we do. There are a number of Saved Queries in the Operations tab with various filters & "and's" & "or's" conditions.

                      I will have to speak to my programmer about the "object_operation("query","queryOperationName","","delete")

                      I do not understand your remark "...DeWayne must be referring to something else such as the filters that are produced by these queries...maybe these only reach a certain number and then the earliest deleted???"

                      The delete operation above could be what we need. THANKS.

                      dewayne

                      Originally posted by MikeC View Post
                      Tom.

                      In runtime (I used a version 5 runtime version of my current App), Open a form or browse, go to the top menu and choose Query-->Query Genie.

                      Choose some filter criteria that suits the form/browse. Now choose the save icon on the bottom of the filter genie and save the query. This query will now be one of the saved queries that are under the Operations tab of the control panel (along with any saved queries created during development).

                      The only way I can see to delete such a saved query would be to use the function I showed in the prior post

                      object_operation("query","queryOperationName","","delete")

                      But the question remains--Is there not a very high number of these that can be saved in the operations area?? So DeWayne must be referring to something else such as the filters that are produced by these queries...maybe these only reach a certain number and then the earliest deleted??? Which is really nothing to be concerned about seeing as how these filters are only produced when a query is run.

                      DeWayne still has not answered all the questions asked so I am at a loss as to whether what I stated here and before is correct or .....

                      Comment


                        #12
                        Re: How to delete a custom query

                        DeWayne,

                        There is a limit as to how many queries can be saved per data file & the oldest gets deleted if you exced the limit.
                        This is what I was referring to and what I do not understand where the problem is. If there is a limit on how many Saved Queries you can have under the Operations tab it must be a very large amount. The only thing I could even guess at what you meant was

                        "...must be referring to something else such as the filters that are produced by these queries...maybe these only reach a certain number and then the earliest deleted???"
                        Just color me confused! :)

                        But hopefully the function I found will do what you want. I would perhaps use a variable for the query name and have a way to set it prior to pressing a Query Delete button...Very possible to have an xDialog come up which lists the names of all the saved queries and then pick the one you want---there was one produced today by Mike Wilson for doing a similar task with reports.



                        This thread has definitely been beneficial for me (and hopefully others as well) in that I had no idea a query could be saved during runtime like you (or your users) have done.
                        Mike
                        __________________________________________
                        It is only when we forget all our learning that we begin to know.
                        It's not what you look at that matters, it's what you see.
                        Henry David Thoreau
                        __________________________________________



                        Comment


                          #13
                          Re: How to delete a custom query

                          Mike, thanks. I did not realize that the runtime user could save a query operation defined with the query genie. I think a script could be written that would list the saved query operations for a table and then delete the one selected by the user. It looks like this would have to be done separately for each table that might have a saved query operation. I don't see a way for the runtime user to delete a saved query operation from the control panel.

                          Later...
                          Here's an example cobbled together from Alpha Sports. Unzip to empty folder. Use the default form and the query genie to define and save a few queries. Then run the DelCustQryOp script on the Code page of the control panel to delete one.

                          If you want to test this in the runtime use the button on Form1, since the Code page of the control panel is not available to the runtime user.
                          Last edited by Tom Cone Jr; 11-20-2007, 06:44 AM. Reason: Attach example

                          Comment


                            #14
                            Re: How to delete a custom query

                            For anyone that comes across this thread in the future.

                            I was faced with the same problem, so taking the information in this thread I was able to create a very simple script to allow the end user to delete Queries.

                            It can be found at the following post 110212-Script-for-end-user-to-delete-user-created-Queries

                            Comment

                            Working...
                            X