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

$25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

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

    $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

    No answers received through response #13, below. If you know the answer, please reply!

    Scenario
    1. A dialog exists with several fields on it.
    2. A user must scroll the dialog vertically to access all fields on the dialog.
    3. Some fields on the dialog are validated using 'Validation rules'. One field is validated using 'Validation Xbasic'.
    4. 'Dialog Properties > Validation and Error Reporting > Error style' = "Tip".
    5. There is a 'Submit' button at the bottom of the dialog.

    The Problem
    1. The user enters data on the dialog.
    2. The user leaves at least one field invalid (e.g., it's left blank).
    3. The user clicks 'Submit'.
    4. Fields with validation errors are highlighted but the user does not see them because the invalid fields have scrolled off the screen.

    What I Want to Happen
    • Excellent Solution: The dialog scrolls to the first invalid field, that field is given focus, and the error message appears in an alert.
    • Very Good Solution: The dialog scrolls to the first invalid field and that field is given focus.
    • Good Solution: The dialog scrolls to the first invalid field.
    • Fair Solution: 'Dialog Properties > Validation and Error Reporting > Show message on Dialog if it has field validation errors' = "True" and the dialog scrolls to the top to display the value of 'Dialog Properties > Validation and Error Reporting > Show message on Dialog if it has field validation errors'.
    • Acceptable Solution: Anything that actively and clearly informs the user that there are errors on the dialog.

    Please: do not guess, speculate, make cracks, or admonish me to write javascript validation formulas.
    Last edited by lsprowls; 01-22-2013, 10:56 PM.

    #2
    Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

    Does this qualify?

    See image...

    Dialog validation errors.gif


    P.S. You have a lot of rules.
    Peter
    AlphaBase Solutions, LLC

    [email protected]
    https://www.alphabasesolutions.com


    Comment


      #3
      Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

      Hi Lawrence,

      The first thing I would suggest is you change the design of the dialog so the user does not need to scroll. Use Tabs if there are that many fields.
      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


        #4
        Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

        Answer to Mr. Greulich: No.
        Answer to Mr. Hubert: I don't want to change the dialog design.

        Comment


          #5
          Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

          Ouch! Somebody needs a Snickers bar.

          Comment


            #6
            Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

            Is a joke that's not at your expense considered a making a crack? You know, since I'm making fun of users in general I figured it would be OK. And I just can't help myself.

            Plus has anyone made an ajax callback joke before?

            If you don't want to read it you don't have to highlight the below

            Here's the answer to all user complaints....plus you can put it in

            function doesUserHaveAClue as c (e as p)
            dim cmd as C
            dim cn as SQL::Connection
            dim args as SQL::Arguments
            args.add("currentuser",a5ws_getcurrentuser())
            cn.open("::Name::CONNECTION")
            dim sqlCommand as c = "SELECT * FROM users WHERE Clue > 0 AND User = :currentuser"
            if cn.Execute(sqlCommand,args)then (it won't matter because no rows will be returned)
            else cmd = "alert('+ js_escape(cn.CallResult.text) + "User has no clue"');"
            end if
            doesUserHaveAClue = cmd
            end function

            Comment


              #7
              Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

              Mr. Cone and Mr. Jinx: Since you don't have the answer, stop wasting my time (and that of everybody who reads this thread) by posting. And don't reply.

              Comment


                #8
                Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

                Originally posted by lsprowls View Post
                Mr. Cone and Mr. Jinx: Since you don't have the answer, stop wasting my time (and that of everybody who reads this thread) by posting. And don't reply.
                Lawrence,

                I believe you have grossly underestimated the folks who respond or read the threads on the message board. Life w/o humor is too serious and too serious a life may cause physical ailments. Hmmm, I think it says somewhere that "laughter is good for the soul". On a more serious note, you may have alienated those who either have responded or are yet to read this thread. No doubt, you'll probably consider this post a waste of your time as well. If so, Es una Lastima!!
                TYVM :) kenn

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

                Comment


                  #9
                  Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

                  Originally posted by lsprowls View Post
                  Mr. Cone and Mr. Jinx: Since you don't have the answer, stop wasting my time (and that of everybody who reads this thread) by posting. And don't reply.
                  Lawrence,

                  I believe you have grossly underestimated the folks who respond or read the threads on the message board. Life w/o humor is too serious and too serious a life may cause physical ailments. Hmmm, I think it says somewhere that "laughter is good for the soul". On a more serious note, you may have alienated those who either have responded or are yet to read this thread. No doubt, you'll probably consider this post a waste of your time as well. If so, Es una Lastima!!
                  TYVM :) kenn

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

                  Comment


                    #10
                    Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

                    For only $25, without seeing the dialog in question, I'd rather donate the time to
                    solving the problem of someone that gives enough information to come up with an answer.
                    Gregg
                    https://paiza.io is a great site to test and share sql code

                    Comment


                      #11
                      Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

                      Anybody who has an answer to my question, please post it! Ignore entries #2-10, above, and #12 below. Earn $25!
                      Last edited by lsprowls; 01-22-2013, 10:52 PM.

                      Comment


                        #12
                        Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

                        Originally posted by lsprowls View Post
                        Anybody who has an answer to my question, please post it! Ignore entries #2-10, above. Earn $25!
                        Lawrence

                        You made two mistakes in the same thread.

                        Consider removing your comment from post 11. Probably too late for the other post to be removed by you, but it can be removed by a moderator.

                        In the meantime I suggest this reading for you.

                        The reading would prove more valuable than a comical offer of a paltry sum.
                        Al Buchholz
                        Bookwood Systems, LTD
                        Weekly QReportBuilder Webinars Thursday 1 pm CST

                        Occam's Razor - KISS
                        Normalize till it hurts - De-normalize till it works.
                        Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
                        When we triage a problem it is much easier to read sample systems than to read a mind.
                        "Make it as simple as possible, but not simpler."
                        Albert Einstein

                        http://www.iadn.com/images/media/iadn_member.png

                        Comment


                          #13
                          Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

                          Originally posted by lsprowls View Post
                          Anybody who has an answer to my question, please post it! Ignore entries #2-10, above. Earn $25!
                          Telling people to ignore something is the same as saying sic'em to a dog! man this is getting better by the post. I haven't had entertainment like this in a long, long time. Even though it's sad, it's also making me With that, I'll [try] to refrain from further chatter.
                          TYVM :) kenn

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

                          Comment


                            #14
                            Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

                            Shooting for acceptable here...

                            Submit button onClick:
                            Code:
                            A5.msgBox.show('Saving Record','<div style=\'padding: 20px;\'><img src=\'CSS/A5System/Images/waitsave1.gif\' />Please Wait - Validating and Saving Record...</div>','none',function() {});
                            {dialog.Object}.submit();
                            Client-Side afterValidate:
                            Code:
                            if (e.hasErrors) {
                            	A5.msgBox.show('Warning','<div style=\'padding: 20px;\'><img src=\'validationerror.png\' />There was a validation error saving.  Close this notice and look for validation errors to correct.</div>','none',function() {});
                            } else {
                            	A5.msgBox.hide();
                            }
                            You can obviously replace the images and wording of the messages in these.

                            And for what it's worth, I would've balked at the money and said I've gotten a lot more than $25 worth of code, design, and ideas from the forum from generous folks, but I figure it can't hurt to take your money and send it on to a charitable organization. You could've gotten the answer from me for free, but your attitude toward others here likely would have discouraged my sharing, so the $25 is probably the only thing that got you your answer.
                            Last edited by christappan; 01-23-2013, 12:42 AM.

                            Comment


                              #15
                              Re: $25 for the Best Answer for Active Display of Dialog Field Validation Errors!!

                              Add this to the dialog's dialogValidate server side event and check the box in the dialog's "Submit dialog if has client-side validation errors" property. I believe it meets all the criteria for excellent.

                              Code:
                              if e.rtc.a_fieldValidationErrors.size() > 0
                              	dim errorcontrol as c
                              	dialogValidate.hasError = .t.
                              	dialogValidate.errorText = e.rtc.a_fieldValidationErrors[1].errorText
                              	errorcontrol = upper(e.rtc.a_fieldValidationErrors[1].varName)
                              	e.javascript = "{dialog.Object}.setFocus('"+errorcontrol+"');alert('"+e.rtc.a_fieldValidationErrors[1].errorText+"');"
                              end if
                              The code above will move the focus to the first control that has an error in it and pop up an alert with the error text that was defined for the control. Even if the control is on a tab pane that is hidden.
                              Jim Coltz
                              Alpha Custom Database Solutions, LLC
                              A5CustomSolutions.com
                              [email protected]

                              Comment

                              Working...
                              X