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

Xdialog, Xbasic for Data Entry

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

    #46
    Re: Xdialog, Xbasic for Data Entry

    Ronald,
    You are talking about a simple application and a dialoge form is the right selection for that.
    But what about a 1 to many realtion set data entry like an Invoice entry?

    Comment


      #47
      Re: Xdialog, Xbasic for Data Entry

      You are talking about a simple application and a dialoge form is the right selection for that.
      But what about a 1 to many realtion set data entry like an Invoice entry?
      No, not really. The previous example is one table of a set.

      It doesn't matter if your filling out an invoice. Your still working with the underlying tables. With xbasic, you can manipulate the entry however you wish. I've attached 2 more screen shots of data entry on an invoice. The invoices are a little crude as they were designed about 10 years ago. They work and the customer is happy with how they work, so I have never bothered to enhance the layout.

      In addition, Dr. Peter Wayne has written in the past about NOT building an invoice like this one as there is a performance hit when navigation between records. His recommendation as I understand it, only navigate using the header. Then open a form to add/edit in my case what would be a tab.

      The image adding labor: without getting really technical, the record is not locked until adding labor. The entry and any computations are handled by xbasic.

      The image adding parts: The entry is handled using xbasic and depending on what the user selects on the xdialog, a new part COULD be added to the inventory table at the same time.

      The examples I have attached are from an invoicing application where we have had as many as 1000 parts items used and as much as 1000 hours of labor. To date, one invoice was over 50 pages long.

      For me, using an xdialog is all about control and/or simplifying data entry for the customer.

      This subject has been covered many times before here. Search of this board will find similar topics with about the same result.
      Attached Files
      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


        #48
        Re: Xdialog, Xbasic for Data Entry

        Renny,

        See this: http://msgboard.alphasoftware.com/al...entry-amp-edit

        Comment


          #49
          Re: Xdialog, Xbasic for Data Entry

          I created a progressive lookup window using the xdialog.
          How will I move the pointer in the table as per the selection in the lookup window?
          pls help.

          Renny

          Comment


            #50
            Re: Xdialog, Xbasic for Data Entry

            Conversely, I use almost exclusively forms. Now, let me qulify this a bit.

            I have one form that has NO table fields on it, but has around 65 editable variables and another 30 or so non editable variable. I guess that is similar to a dialog? User fills in the data, data is checked via xdialog, and either saved to the table(s) or user is taken back to the form to fix what user did not do or did not do correctly.

            Browses: I use them to display data! Mostly not editable. I have and do have a couple of embedded browses that can be edited on a form. I use embedded browses as a search method.

            In selling a car, there is a bunch of math to do. After years of work, I found it easier to use variables and do the math with code. At first, I copied the tables fields to variables, did what I needed and copied them back to the fields. Later figured out to just put it all in variables at the beginning and only save it when done.

            Point: you can work almost completely in vars and then save it if that is what is needed or makes the most sense.

            Reckon I am just a bit behind in this.
            Dave Mason
            [email protected]
            Skype is dave.mason46

            Comment


              #51
              Re: Xdialog, Xbasic for Data Entry

              Hi Renny,
              I created a progressive lookup window using the xdialog.
              Did you state with the variable that you wanted the Recno() to be returned?
              Regards
              Keith Hubert
              Alpha Guild Member
              London.
              KHDB Management Systems
              Skype = keith.hubert


              For your day-to-day Needs, you Need an Alpha Database!

              Comment


                #52
                Re: Xdialog, Xbasic for Data Entry

                keith,
                How would I do this to get the record no?

                Comment


                  #53
                  Re: Xdialog, Xbasic for Data Entry

                  Hi Renny,

                  Please see attached of progressive Lookup I made for Alphasports.

                  I used Customer_id as the returned value.
                  Attached Files
                  Regards
                  Keith Hubert
                  Alpha Guild Member
                  London.
                  KHDB Management Systems
                  Skype = keith.hubert


                  For your day-to-day Needs, you Need an Alpha Database!

                  Comment


                    #54
                    Re: Xdialog, Xbasic for Data Entry

                    Keith,
                    You use record listbox, which has no option for field level sorting by clicking on the header.
                    That is why I used list view control.
                    Yes I found "Field to Return" in list view control, hope this will solve my problem.

                    Thanks

                    Comment


                      #55
                      Re: Xdialog, Xbasic for Data Entry

                      Nice example Keith
                      I would never have thought of using a filter to be dynamic that way in the wizard, that anyone can use.
                      I've seen it used in xbasic dialog samples but I'm not much good with coding Xdlgs
                      So thanks for sharing that.

                      Comment

                      Working...
                      X