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

An error or WHAT am I doing wrong?

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

    An error or WHAT am I doing wrong?

    In the control panel FORM TAB of the attached database, click on Invoice Payments. This for is sorted on Status="Open" in the status field. You should see invoice numbers starting with 15xxx; sometimes it comes up showing ALL invoices ie invoice numbers starting at 000000xx. Move the cursor down off the first invoice in the INVOICE browse and highlite the row; move over to payments side to apply any payemnt - date & amt etc. When you click on the line for the new record on the payment side the invoice Browse JUMPS OFF the current invoice number.. WHAT is happening and why?

    DonW

    #2
    RE: An error or WHAT am I doing wrong?

    Hello Don,

    >>In the control panel FORM TAB of the attached database

    Comment


      #3
      RE: An error or WHAT am I doing wrong?

      OOps,

      I went back into your message and now the attachment shows up. Curious.

      Jim

      Comment


        #4
        RE: An error or WHAT am I doing wrong?

        Don,

        I looked at this briefly and found it very curious. I've seen the exact same behavior in A5v4.x when, as in your situation, the parent record of a set is displayed in a browse. In the past, I've solved this problem by simply putting a field from the parent table on the form outside of the browse. In your sample, doing this did not change a thing.

        I went looking for an event or field rule that might be interferring, but was unable to quickly spot anything. I put some xbasic in events to try to track the record pointer, and it appearS that the parent record pointer IS remaining on the correct record, even though the invoice browse is jumping around.

        I will look at this further when I have a little more time. I'm curious to see if anyone has some insight as to what is happening here.

        Jim

        Comment


          #5
          RE: An error or WHAT am I doing wrong?

          Hello Don,

          I don't have an answer for you, but I do think I've found the culprit. If you remove the posting rule in the payments->Check_amt field the problem goes away. This is not a solution as you should be able to use posting in this situation.

          Again, everything appears to work, but the invoice browse jumping to a different record gives immediate and strong indication that it is not working.

          I hope that someone from Alpha weighs in on this. This is disconcerting.

          Any other of you late night Alpha-holics looking at this??

          Jim

          Comment


            #6
            RE: An error or WHAT am I doing wrong?

            Hello Don,

            Another interesting observation, you have a filter on the invoices table: Status="Open" .OR. Status="Overpaid".

            If, for instance you select the 8th record in the filtered list of records from the 'invoices' table, and enter a new payment record in the payments table, the invoices browse jumps to the 8th record of the UNFILTERED order.

            If you are on the 5th record of the filtered order, and enter a new payment record, the browse jumps to the 5th record of the UNFILTERED order.

            If you remove the filter, it works fine, without the invoices browse jumping around.

            At this point it appears to me to be a bug.
            A bug that appears when you have a child posting rule and a filter on the parent, and a parent browse.



            Jim

            Comment


              #7
              RE: An error or WHAT am I doing wrong?

              i haven't looked at your tables but i have sent examples to alpha of similar behavior (what i call "flyaway" of the record) in other forms with browses. i have been assured that alpha is aware of the problem and is rewriting the code for browses in hopes of fixing this flyaway problem. in all the examples that i have found, it's really a cosmetic problem, as alpha's internal pointers are correct but the browse focus appears to be on the wrong parent record. nevertheless it's very disconcerting to data entry people.

              Comment


                #8
                RE: An error or WHAT am I doing wrong?

                Hello Peter,

                Good to hear from you.

                >>it's really a cosmetic problem

                Comment


                  #9
                  RE: An error or WHAT am I doing wrong?

                  Jim

                  Thanks VERY much for looking into this. Concerning the idea that it is cosmetic - maybe but the users don;t want to use the form! I feel as you do that it SHOULD work this way! They might be able to live without the filter for a time.

                  Comment

                  Working...
                  X