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

A5V9 Index Challenge

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

  • A5V9 Index Challenge

    I know this has been answered on the forum before, but cannot find it.
    Every time I close and re-open my browse table, the Index returns to "Recod Number Sequence" rather than the Index I last used. Where is the trigger to reset the system so Browse Tables will return to the last Index used????
    Thanks Walt

  • #2
    Re: A5V9 Index Challenge

    Originally posted by Wdfranklin View Post
    I know this has been answered on the forum before, but cannot find it.
    Every time I close and re-open my browse table, the Index returns to "Recod Number Sequence" rather than the Index I last used. Where is the trigger to reset the system so Browse Tables will return to the last Index used????
    Thanks Walt
    Actually the index stays as the 'chosen' one unless something (ie code)changes the index....

    So I'd look for what is changing the 'chosen' index. Like the oninit or onactivate events... but not limited to... or any other event/code that is run....
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

    Comment


    • #3
      Re: A5V9 Index Challenge

      Walt, you might also check the status of the "use last run query" toggle on the Filter/Order tab of the browse layout properties dialog. I believe the last used "index" will stick if this is toggled on.

      Comment


      • #4
        Re: A5V9 Index Challenge

        Originally posted by Wdfranklin View Post
        I know this has been answered on the forum before, but cannot find it.
        Every time I close and re-open my browse table, the Index returns to "Recod Number Sequence" rather than the Index I last used. Where is the trigger to reset the system so Browse Tables will return to the last Index used????
        Thanks Walt
        Thanks so much, makes sense. Walt

        Comment


        • #5
          Re: A5V9 Index Challenge

          Thanks so much, will research, makes sense

          Walt

          Comment


          • #6
            Re: A5V9 Index Challenge

            Will do later today, thanks

            Walt

            Comment


            • #7
              Re: A5V9 Index Challenge

              Okay, I just updated from V8 to V9, build 3264 and have the same problem. If I open an existing table in v9 (using the Alpha 5 default browse) and select the index by Primary Index or Key on the main toolbar, the indexing is correct. If I close the table and open it back up, the index, as above, is now the record/number index. If I open the same table in v8 and set the index in the same manner, the index is retained when I close and reopen the table.

              I followed the advice provided by Tom Cone, above, and it works. However, when you change the "use last...." and try to close the table, A9 forces you to provide a new name for the browse. Then, you have to use this browse all the time. Why should I have to do this? For 19 years I've been double clicking to open a table into the Alpha default browse and really don't want to have to create and remember to use an alternate browse for every table.

              Does anyone have any suggestions on how to avoid having to create a new browse for every table?

              Comment


              • #8
                Re: A5V9 Index Challenge

                Not sure about v9 but v8 stores the last used index in

                Code:
                HKEY_CURRENT_USER\Software\Alpha Software\Alpha Five 8.0\Tables\sometablename.dbf
                You might check to see what v9 does, if anything.
                There can be only one.

                Comment


                • #9
                  Re: A5V9 Index Challenge

                  Thanks for your response Stan but it doesn't solve the problem.

                  For both V8 and V9, in the registry (64 bit Vista), the Indx entry for the .alb file is-
                  Record-number;NAME = 'Global_Variables' .AND.

                  The Indx entry for the .dbf file is-
                  Locationitemdescribe

                  The latter is the index I normally use however, despite what the registry says, V9 will not retain this index when I close the .dbf file. It does save it if I use the new browse I created but I don't want to create new browses for all my tables.

                  Interestingly, V8 doesn't have the "use last...." option in the browser layout filter properties. It must either be built into the software code or is somewhere else.

                  It's also interesting that V8 won't read the new browse created in v9.

                  Do you or anyone else have any ideas? I guess i could go to Alpha Software about it but want to do this as a last resort.

                  Comment


                  • #10
                    Re: A5V9 Index Challenge

                    Tom,

                    "use last run query" toggle on the Filter/Order tab of the browse layout properties dialog.
                    I must be blind. Where do you see that toggle? I've looked several times without luck so might need a screen shot!

                    Bob Arbuthnot

                    Comment


                    • #11
                      Re: A5V9 Index Challenge

                      Bob, as indicated it's on the Filter/Order tab of the saved layout. Robert M is talking about the behavior of the "default browse" which is a different thing.

                      -- tom

                      Comment


                      • #12
                        Re: A5V9 Index Challenge

                        Anyone else before I ask Alpha? I'm really amazed this hasn't caused consternation for more people who migrate from v8 to V9.

                        Comment


                        • #13
                          Re: A5V9 Index Challenge

                          Robert,

                          I am not sure about anyone else but I find myself only using the default browse when I need to check on a field that is not displayed on one of my designed forms. I spend as much time as possible in the forms and reports that I design so that I am always testing those forms and reports. I may go days without using the default browse. I am not saying that it is not a problem or that it should not be fixed but just that some of us do not use it enough to notice or be bothered by the problem. I would suggest that you do submit a bug report on the issue.
                          Jeff Ryder

                          Comment


                          • #14
                            Re: A5V9 Index Challenge

                            I never use forms because I don't need them, so I just use the default browse. The concern is having to create a new browse for every table in every database that I have. It shouldn't be that way (and never has been until V9). Unless someone else has any other ideas, I'll submit a bug report. There be a way to modify the default browse during A5 startup. Seems that someone always comes up with a way to modify A5 code.

                            Comment


                            • #15
                              Re: A5V9 Index Challenge

                              Robert, personally I think this should be a user preference item. I think the default browse should be created and displayed exactly the same way, regardless, of what I did with it the last time I worked with it. However, I can see how you've come to depend on a different behavior. Perhaps they can make us both happy by offering a new user preference setting.

                              I think you should submit a bug report, and in the bug report you might mention that if the powers that be have made the change on purpose it would be very much appreciated if the previous behavior could be made available through a user preference setting.

                              Comment

                              Working...
                              X