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

'Locate' doesn't work - nothing happens

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

    'Locate' doesn't work - nothing happens

    I am using A5v7 3906-3009.

    I want to use the 'find text' locate dialog box (see attached jpeg below) to find all records in a table containing text I specify. I can do this by opening my table in the A5 control panel and selecting the 'Find' menu/'Find text' option and entering my search. It works perfectly.

    Now when I try to do exactly the same thing by clicking on a button on a form, nothing happens - the same locate dialog box will NOT appear, no matter how I try.

    I have attached a very simple example as an A5 database (as testit.zip). There is a single table and a single form in this application. The OnPush event for the button on the form has been set up using the action script pre-defined button for 'Find'/'Find text'.

    If I click on this button nothing happens. I have even tried attaching the same Action Script generated Xbasic code 'topparent.command("LOCATE")' directly to the button's OnPush event. Again - nothing happens.

    There is no way I have been able to discover that will pop-up the 'find text' locate dialog box.

    Can anyone tell me how I can do this?

    Thanks.

    #2
    Brett,

    I haven't used LOCATE in a long time, but here's what I'm seeing with build 3909_3011:

    Action Scripting offers 2 ways to do the LOCATE.

    a) in the one you've chosen the Action prompts you to specify a form level menu choice to run and the form's Find Text menu choice is activated. For this to work the fields you want to search apparently must be displayed in the form. You don't have any field objects in the form. Instead the fields are being displayed in columns inside an embedded browse object. If you add the field objects for the fields you'd want to search your button will start working.

    b) in the second approach you can choose the action to "Locate Text", then tell the action scripting genie which fields to search and the direction of search. When the script runs this will then popup an input dialog and do the search for you, using the parameters you've specified. In this latter approach you do NOT have to have field objects in the form layout. Your embedded browse object works just fine.

    -- t

    Comment


      #3
      Thanks, Tom. I am committed to using option 'a' as option 'b' is a little too basic for my needs.
      So I have placed the two fields I want to search on in my form and, yes indeed, the find text works as advertised now. :)
      So my next idea (because I don't want the two fields to show) was to have them on the form but hide them. Result - one really obscure dialog box error message (attached). So I have tried some more fiddling around with various combinations of hide, read-only and disable on the fields, but with limited success I'm afraid - same error message. My next idea is to hide the fields on the form behind another object - perhaps a nice picture of the asylum where I might end up living...
      I'm sure I can work something out now that I know. Thanks again.

      Comment


        #4
        OK, I think I have it worked out now.

        My problem was that I had to show the fields on a form that I wanted to use with the 'find text' Action Script. But I already had the same fields in a browse on the same form and the form design looked a mess with the fields repeated. So what did I do?

        I tried placing the fields on the form and using the hide and/or disable properties for them, but this only gave more of the obscure error message dialog boxes I have described above.

        So I tried hiding the fields behind another object on the form. No, this didn't work as they would always bleed through after a find.

        So finally I found that if I made the fields as small as possible, removed their border and set them to transparent, this just left the text of the information in the field that showed. So I made the font to the smallest I could (4 point) and chose a font color that blended in with my form background. I then placed the fields on the top left of my form so that I could find them again!

        Not a perfect solution but something I can live with. (Ohmygosh, I have spent hours on this).

        Comment

        Working...
        X