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

Learning Alpha 5 V10

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

    Learning Alpha 5 V10

    Hi All,

    I'm an Access Developer (pretty much expert level) and I'm looking at Alpha 5 V 10 as an alternative. What's the best way to learn Alpha 5. I'm not seeing any books. Not sure if I'll be able to get to the seminar in Boston. I've been poking around Alpha Sport and trying to piece things together looking at the videos but is there a better way?

    Please let me know.

    Eddie

    #2
    Re: Learning Alpha 5 V10

    Alpha has a tutorial and samples included (free) with the program you should go through, A third party tutorial called Alpha Five Made Easy by Susan Bush will (should) be out at the end of the month for v10, Dr. Peter Wayne's Xbasic For Everyone is another good choice....the beginning parts of his book says no assumptions are made as far as being a programmer but some are made--your coming from access, these few assumptions should not be an issue. The same is true for the tutorials as well--a complete programming novice may have a little difficulty with them.

    All of the above are very reasonably priced IMO as well. This messageboard can also be used to learn as well (MANY samples are attached to posts) as it is treated mainly as a knowledgebase and not as a place to converse.
    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


      #3
      Re: Learning Alpha 5 V10

      IADN is starting a series of classes in February. Click the Training Schedule icon on this page: www.alphadevnet.com

      Please note: IADN classes are scheduled to start in February but exact schedule and other details are not yet established. Class offers subject to change and no reservations are being taken at this time. Signup for a Free or paid account and we will keep you informed.
      Steve Wood
      See my profile on IADN

      Comment


        #4
        Re: Learning Alpha 5 V10

        Mike C. thanks for the info. Great information! I'm not seeing the tutorial you say came with the program. My copy was purchased for me by the company that wants me to use Alpha 5 to develop and I downloaded an online copy. Is this a disk that comes with the box?

        Looking forward to Alpha Five Made Easy. Hope it comes out soon.

        Also, the xBasic book says it covers V8. Is there a book that covers V10?

        Steve I signed up for a free account on the Developer Network. Thanks.

        Comment


          #5
          Re: Learning Alpha 5 V10

          Alpha tutorial is found via Online Help which should be bookmarked.
          There are also videos available for new features in v10.
          Xbasic For Everyone later versions are only available as PDF.

          http://alphasoftware.com/video/v10/
          http://support.alphasoftware.com/alp...pv10/index.htm

          Alpha seems to have dropped the ball regarding Dr. Waynes Xbasic For Everyone as you are correct in that only the v8 is available in their store. Do a search here for the books title and/or Peter Wayne as I know there was a link posted in a thread a few months ago.
          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


            #6
            Re: Learning Alpha 5 V10

            Originally posted by eantar View Post
            Mike C. thanks for the info. Great information! I'm not seeing the tutorial you say came with the program. My copy was purchased for me by the company that wants me to use Alpha 5 to develop and I downloaded an online copy. Is this a disk that comes with the box?

            Looking forward to Alpha Five Made Easy. Hope it comes out soon.

            Also, the xBasic book says it covers V8. Is there a book that covers V10?

            Steve I signed up for a free account on the Developer Network. Thanks.
            Hi Eddie,

            You willl find numerous ex Access users now using A5. My experience was trying to do things in A5 the way it was done in Access was a big bust. The basic A5 stuff is pretty easy but you MUST not think Access when working with A5. If you do, you WILL be in for a lot of frustration, to say the least.

            No books, etc out thus far for v10 but again, poke around and you'll be pleasantly surprised.

            I would shy away from Xbasic for now only because I believe it's important for you to become familiar with A5 first. With A5 open, click on Help menu and open A5 help. You will find plenty of info to help get you going.

            kenn
            TYVM :) kenn

            Knowing what you can achieve will not become reality until you imagine and explore.

            Comment


              #7
              Re: Learning Alpha 5 V10

              Hi Ken,

              Thanks for your message. It's very frustrating that there isn't any book or video series. For me that would be the best way to learn. Still, with the help and going through the videos I'm hoping to make a dent.

              Yes, it seems that trying to develop as an Access developer would indeed frustrate me as things are done differently in Alpha land.

              So for now I'll keep trudging along with the help and the tutorials.

              Thanks for the comment.

              Comment


                #8
                Re: Learning Alpha 5 V10

                Eddie, even though "Xbasic for Everyone" was written for vers 8, given your background it would be a great way to climb the learning curve for Alpha Five. -- tom

                Comment


                  #9
                  Re: Learning Alpha 5 V10

                  Originally posted by Tom Cone Jr View Post
                  Eddie, even though "Xbasic for Everyone" was written for vers 8, given your background it would be a great way to climb the learning curve for Alpha Five. -- tom
                  Ummmmm, maybe. While this approace is not for most, he might be able to do it but VB and Xbasic are as different as A5 is from Access. Perhaps if he, or anyone else for that matter, establishes a couple of tables and then creates a set followed by forms, use of the Genie to perform or create tasks would be a very good approach. That way, one could convert to Xbasic what the Genie did and learn the gist of how Xbasic is put together.

                  I think trying to learn xbasic before grasping an understanding of A5 is putting the cart before the horse. That doesn't mean it can't be done but for most, I suspect it would lead to undue frustration.

                  Eddie, let us know your aproach and what does and does not work. Of course, there are a lot of variables (no pun intended) for each person but whatever approach you find which works, will definately be a help to others.

                  kenn
                  TYVM :) kenn

                  Knowing what you can achieve will not become reality until you imagine and explore.

                  Comment


                    #10
                    Re: Learning Alpha 5 V10

                    Here are other videos I've found helpful...
                    http://support.alphasoftware.com/Wha...New%20Features

                    Don

                    Comment


                      #11
                      Re: Learning Alpha 5 V10

                      Originally posted by eantar View Post
                      I'm an Access Developer (pretty much expert level) and I'm looking at Alpha 5 V 10 as an alternative. What's the best way to learn Alpha 5.
                      We have books on Alpha Five that will get you off to a quick start in learning available features. In addition to mine, we also carry Dr. Peter Wayne's Xbasic for Everyone.

                      There is a TOC and sample chapters for each book, so you can get an idea of what's covered.

                      Click the Liberty Manuals link below.
                      sigpic Susan Bush, Liberty Manuals Co. Books for Alpha Anywhere mobile, web and desktop.

                      Comment


                        #12
                        Re: Learning Alpha 5 V10

                        Originally posted by forskare View Post
                        ... one could convert to Xbasic what the Genie did and learn the gist of how Xbasic is put together ...
                        While this is basically true, I feel it's only fair to warn new developers that this can also be some very complex xbasic when all that complexity is often unnecessary. As such, it can make xbasic look much more difficult than it really is.

                        I think of "xbasic" as Basic (as in the old DOS stuff) but with many (many, many, many?) new functions for handling a database - and HTML, and FTP, etc.

                        There is some justification for the complexity. When building a Genie it's rather hard to tell how and where developers will use that Genie so it's important to add "safety factors" - various checks, conversions, etc. However, when creating your own code you should know exactly what you are doing with it. Which means all that other "stuff" can go away.

                        EXAMPLE:

                        The code created by the Alpha genie to open a form:
                        Code:
                        [COLOR=darkorchid]DIM Shared varP_Company_Info as P
                        DIM layout_name as c 
                        [/COLOR]layout_name = "Company_Info"
                        [COLOR=darkorchid]DIM tempP as p[/COLOR]
                        [COLOR=blue]'Get pointer to existing window. In case layout_name is qualified with a dictionary name, extract up to first @. In case formname has spaces, normalize it
                        [/COLOR]tempP=[COLOR=darkgreen]obj([/COLOR]":"+[COLOR=darkgreen]object_Name_normalize(word([/COLOR]layout_name,1,"@"[COLOR=darkgreen])))[/COLOR]
                        [COLOR=blue]'Test if pointer is valid
                        [/COLOR]if [COLOR=darkgreen]is_object([/COLOR]tempP[COLOR=darkgreen])[/COLOR] then 
                        [COLOR=blue]   'Test if pointer refers to a form or browse
                        [/COLOR]   if tempP.[COLOR=darkgreen]class()[/COLOR] = "form" .or. tempP.[COLOR=darkgreen]class()[/COLOR] = "browse" then 
                              [COLOR=blue]'If so, then activate the already open window
                        [/COLOR]      tempP.[COLOR=darkgreen]activate()
                        [/COLOR]   else
                             [COLOR=blue] 'Window is not already open, so open it
                        [/COLOR]      varP_Company_Info = [COLOR=darkgreen]:Form.view([/COLOR]layout_name[COLOR=darkgreen])[/COLOR]
                           end if
                        else 
                           varP_Company_Info = [COLOR=#006400]:Form.view([/COLOR]layout_name[COLOR=darkgreen])[/COLOR]
                        end if
                        Code I would normally use to open the same form:
                        Code:
                        fp = [COLOR=darkgreen]form.view([/COLOR] "Company_Info" [COLOR=darkgreen])[/COLOR]
                        I don't like typing any more than I need to so my standard is "fp" means "form pointer" and "tp" means table pointer. If I open multiple forms or tables in the same script, fpc might mean "form pointer to the Company_Info form", etc. I'd much rather type 3 characters that make sense if you understand what's going on than type 17 characters every time I want to use that variable. (Another option to save typing and still get the full names is to use abbreviations initially then use a global search and replace when the script is done. Of course, if you start doing that you will soon discover that the shorter names work just fine and won't bother with the search and replace anymore.)

                        BY THE WAY, thinking of names, I'm probably fairly well known for my concern about naming methods and I can guarantee you that the methods you used in Access will NOT work well in A5. One obvious example is that you cannot name a field MyCharField in alpha because it will come out as Mycharfield no matter how many times you try to change the capitalization. Same is true for index names - ndxCustID will come back as Ndxcustid. Given that intro, here (for the upteenth time) is a link to my A5 Naming Recommendations page.
                        Last edited by CALocklin; 08-05-2010, 11:34 PM.

                        Comment


                          #13
                          Re: Learning Alpha 5 V10

                          Originally posted by CALocklin View Post
                          While this is basically true, I feel it's only fair to warn new developers that this can also be some very complex xbasic when all that complexity is often unnecessary. As such, it can make xbasic look much more difficult than it really is.
                          Cal - It is true that I put the emphasis on what you can do without Xbasic and, believe me, the results that can be achieved are quite amazing. There are some of us who do not have the time nor want to take the trouble to learn programming. For others, such as yourself, it is the only way to go. And I am the first to say that Xbasic gives further opportunity to enhance applications.

                          Isn't it great that Alpha Five is the answer for both of us? :)

                          Susan
                          sigpic Susan Bush, Liberty Manuals Co. Books for Alpha Anywhere mobile, web and desktop.

                          Comment


                            #14
                            Re: Learning Alpha 5 V10

                            Originally posted by susanhbush View Post
                            ... Isn't it great that Alpha Five is the answer for both of us? :)
                            Absolutely. And I didn't mean to detract from using Action Scripting. My only concern was that I've talked with a number of developers who decided that xbasic was too hard to learn because they saw how complicated the Genie code is. Since the original poster said he was pretty much at the expert level in Access (that implies at least some use of VBA to me) and implied that he wanted to learn xbasic I thought it might be good for him to know that all those details in the code generated by the Genie are often unnecessary.

                            Comment


                              #15
                              Re: Learning Alpha 5 V10

                              Pretty much following others.

                              for years now, I have done the action scripting and converted it to xbasic, gotten rid of the(to me) garbage. More recent years, most of this was put into a script and lately am converting most of it to UDF's.

                              New programmers need to use the action scripting as much as possible(my opinion) while they learn how to get around in alpha.

                              Cal's naming convention should be used almost like a bible for alpha programmers.

                              All names anywhere should be kept as short as possible and if using xbasic, should be commented(the pain part). I have opened my own code to find I have no idea why I wrote/converted it. I don't like spaces or underscores(takes a letter place). shorter names means less room for errors(King of the errors here!) and more space for code if needed.

                              VB is a whole different subject than a rad like alpha, access and fm. C#, C++ is even deeper, or you can drop to 0's and 1's like asm/masm???


                              I must add the Fantastic report writer in alpha is the closest to Crystal Reports you can get if they would just fix it so we could seperate to an exe to print like Crystal. In other words, be able to generate a report like inventory.exe like Crystal does/can.



                              .
                              Dave Mason
                              [email protected]
                              Skype is dave.mason46

                              Comment

                              Working...
                              X