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

Script for button that shows user groups & users

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

    Script for button that shows user groups & users

    I would like to put a button on a form that shows the following. thanks.

    groups_users.jpg

    #2
    Re: Script for button that shows user groups & users

    Define the script for your button using Xbasic and type (or copy and paste) the following:

    a5_user_groups_dialog()

    Comment


      #3
      Re: Script for button that shows user groups & users

      a5_security_option("Define users and groups")

      Using either option the workspace password must have been set and the user logged in as an administrator.
      There can be only one.

      Comment


        #4
        Re: Script for button that shows user groups & users

        Dr. Peter Wayne's book, "Xbasic for Everyone" has a whole chapter devoted to building xdialogs to manage Security.
        Not sure if the book is still available.
        Alpha 5 Version 11
        AA Build 2999, Build 4269, Current Build
        DBF's and MySql
        Desktop, Web on the Desktop and WEB

        Ron Anusiewicz

        Comment


          #5
          Re: Script for button that shows user groups & users

          As Stan says it is an A5 function.
          I have Peter Waynes book if you nedd specific info. His site probably has some stuff on it too.

          You will still have problems getting a list - which is what you are after I suspect - of group user permissions like you were chasing in another post. Some of tbe A5 functions no longer work.
          See our Hybrid Option here;
          https://hybridapps.example-software.com/


          Apologies to anyone I haven't managed to upset yet.
          You are held in a queue and I will get to you soon.

          Comment


            #6
            Re: Script for button that shows user groups & users

            Originally posted by Stan Mathews View Post
            a5_security_option("Define users and groups")

            Using either option the workspace password must have been set and the user logged in as an administrator.
            Thanks, that did the trick and working OK..your tireless efforts are appreciated by all who walk the halls of this Message Board.

            Comment


              #7
              Re: Script for button that shows user groups & users

              Originally posted by dchiass View Post
              I would like to put a button on a form that shows the following. thanks.

              [ATTACH=CONFIG]43865[/ATTACH]
              Got a solution from Stan but I would also like to create a button for each form & DBF in the application where I can set the permissions.

              This action is being done with RUNTIME alpha

              Pic security on database.jpgPic security on form.jpg
              Last edited by dchiass; 08-21-2017, 10:31 AM. Reason: wrong pic

              Comment


                #8
                Re: Script for button that shows user groups & users

                Originally posted by Ronald Anusiewicz View Post
                Dr. Peter Wayne's book, "Xbasic for Everyone" has a whole chapter devoted to building xdialogs to manage Security.
                Not sure if the book is still available.
                spent 1/2 hour and could not find. seems it mite be vintage 2008 or so.

                Comment


                  #9
                  Re: Script for button that shows user groups & users

                  <broken link> is likewise unavailable.

                  Does anyone know how to contact Dr. Wayne?
                  Last edited by Lenny Forziati; 12-14-2021, 01:01 PM. Reason: broken link removed
                  There can be only one.

                  Comment


                    #10
                    Re: Script for button that shows user groups &amp; users

                    Chapter 32. Run-Time Security
                    Pages 154 thru 174
                    Alpha 5 Version 11
                    AA Build 2999, Build 4269, Current Build
                    DBF's and MySql
                    Desktop, Web on the Desktop and WEB

                    Ron Anusiewicz

                    Comment


                      #11
                      Re: Script for button that shows user groups &amp; users

                      Originally posted by Ronald Anusiewicz View Post
                      Chapter 32. Run-Time Security
                      Pages 154 thru 174
                      please refer to my previous post, where does one find this book...it is not much help referring to pages of a book that is impossible to find. For reference what is the DATE on the book & which Alpha version does it cover?

                      BTW, even if found does that chapter also also applies to an Alpha Anywhere app? Alpha has changed a lot in 8 years.

                      Thanks for the page number.

                      Comment


                        #12
                        Re: Script for button that shows user groups &amp; users

                        Sorry, I misunderstood your post. I took it that you had the book but could not find my reference.
                        Very little has changed from version 11 on.
                        Alpha 5 Version 11
                        AA Build 2999, Build 4269, Current Build
                        DBF's and MySql
                        Desktop, Web on the Desktop and WEB

                        Ron Anusiewicz

                        Comment


                          #13
                          Re: Script for button that shows user groups &amp; users

                          Try this:

                          http://www.libertymanuals.com/xbasic...ok-description
                          Alpha 5 Version 11
                          AA Build 2999, Build 4269, Current Build
                          DBF's and MySql
                          Desktop, Web on the Desktop and WEB

                          Ron Anusiewicz

                          Comment


                            #14
                            Re: Script for button that shows user groups &amp; users

                            Originally posted by Ronald Anusiewicz View Post
                            Tried 4 browsers and it will not go to this link & my AVAST anti virus message says "threat blocked"

                            Comment


                              #15
                              Re: Script for button that shows user groups &amp; users

                              I don't know what to tell you. I'm using Mozilla and OpenDNS and I have no trouble going to this site. Liberty manuals is the company that sells Susan Bush's Alpha software training manuals.

                              Liberty Manuals Company
                              1806 Route 35
                              Suite 104
                              Oakhurst, NJ 07755

                              Tel 732-842-3000 Fax 732-741-5820


                              Xbasic Workbook Description
                              Alpha Anywhere Xbasic Workbook
                              (Formerly Alpha Five: Xbasic for Everyone)
                              by Dr. Peter Wayne

                              This classic has a fresh new look!
                              Only the cover has changed, the content remains the same as in the original book.

                              Published in 2008, this book gives working examples of Xbasic scripts.

                              Dr. Wayne has been involved with Alpha Five since its earliest days and is known for his lucid explanations. He takes the reader all the way from an introduction to Xbasic to sophisticated Xdialog, ActiveX, image display, and AlphaDAO and Javascript. You can even "upsize your database" to MySQL.

                              In addition to teaching Xbasic, Dr. Wayne peppers the book with useful examples showing how to use Javascript and MySQL stored procedures to enhance your enterprise-worthy application.

                              This book is suitable for Alpha Anywhere & Alpha Five V8-11.

                              Includes working databases for the exercises and book in PDF format.
                              Alpha 5 Version 11
                              AA Build 2999, Build 4269, Current Build
                              DBF's and MySql
                              Desktop, Web on the Desktop and WEB

                              Ron Anusiewicz

                              Comment

                              Working...
                              X