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

Correct syntax for or statement in show/hide expression

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

    Correct syntax for or statement in show/hide expression

    I struggling with what should be an easy line of code: I need to hide some fields if a certain condition is met:
    the condition is if the filetype field is not ".mp3 or .m4b" then show the field.
    I tried filetype!=".mp3" and up to that point it works, but if I add the "or" statement I get an error in the syntax or it simply doesn't evaluate right
    This is what I tried:

    filetype!=".mp3" || filetype!=".m4b"
    filetype!=".mp3" or filetype!=".m4b"
    filetype!=".mp3".OR.filetype!=".m4b"


    the show/hide expression says that it evaluates the function using javascript and the correct syntax should be the first one || doublepipelines but I'm getting a syntax error.

    #2
    Re: Correct syntax for or statement in show/hide expression

    Yeah. No. The show/hide logic is not written in javascript. It's compiled to javascript (maybe? I dunno.) What you're asked to write, though, is something else... It's like a bad mashup of xbasic and... well, not javascript:

    Code:
    filetype<>".mp3" or filetype<>".m4b"
    Alpha Anywhere latest pre-release

    Comment


      #3
      Re: Correct syntax for or statement in show/hide expression

      Thank you Sarah, but it is not working. It keeps showing the field, it only works if I leave filetype<>".mp3" or the other, not both with the or.

      Comment


        #4
        Re: Correct syntax for or statement in show/hide expression

        Ok. I am wondering if your logic is solid here. Can filetype be both ".mp3" AND ".m4b" at the same time? Because if it can't, then your statement is always true.
        Alpha Anywhere latest pre-release

        Comment


          #5
          Re: Correct syntax for or statement in show/hide expression

          Originally posted by mastermind315 View Post
          I need to hide some fields if a certain condition is met:
          the condition is if the filetype field is not ".mp3 or .m4b" then show the field.
          You need to use and. IF filetype is not ".mp3" AND filetype is not ".m4b", then show the field.
          Alpha Anywhere latest pre-release

          Comment


            #6
            Re: Correct syntax for or statement in show/hide expression

            no, either the file is .mp3 or .m4b (audio files) and the rest are .mp4, .m4v, .wmv files (video files)
            the fields to be hidden are Frame Width and Frame Height is the filetype is either one of those audio filetypes.

            Comment


              #7
              Re: Correct syntax for or statement in show/hide expression

              Originally posted by mastermind315 View Post
              no, either the file is .mp3 or .m4b (audio files) and the rest are .mp4, .m4v, .wmv files (video files)
              the fields to be hidden are Frame Width and Frame Height is the filetype is either one of those audio filetypes.
              Try this:

              Code:
              filetype<>".mp3" [B][COLOR="#008000"]and[/COLOR][/B] filetype<>".m4b"
              Alpha Anywhere latest pre-release

              Comment


                #8
                Re: Correct syntax for or statement in show/hide expression

                I was able to make it work by using Framewidth <> 0 which is another comparison I can do to get the same result, but the grid keeps showing a little bit of the field row although Collapse is selected in the show/hide expression buidler.

                Comment


                  #9
                  Re: Correct syntax for or statement in show/hide expression

                  Video
                  video.jpg


                  Audio
                  audio.jpg

                  Comment


                    #10
                    Re: Correct syntax for or statement in show/hide expression

                    If that works, then good. I do hope, however, that you noticed that filetype<>".mp3" or filetype<>".m4b" will always evaluate to true whereas filetype<>".mp3" and filetype<>".m4b" will be false when filetype is either .mp3 or .m4b and true otherwise.

                    Not sure about your extra row bits.
                    Alpha Anywhere latest pre-release

                    Comment


                      #11
                      Re: Correct syntax for or statement in show/hide expression

                      Thank you Sarah!
                      I reverted and used the one you suggest with the AND, it works perfectly.
                      Last edited by mastermind315; 05-22-2013, 02:03 PM.

                      Comment


                        #12
                        Re: Correct syntax for or statement in show/hide expression

                        I have a similar situation here that is not working.
                        Show/Hide Expression for Frame:

                        Code:
                        Field1 = Textbox1 and Field2 = Textbox2 and Field3 = Textbox3
                        I keep getting a syntax error. Where is it?
                        Rapid Development, Training, Support
                        http://data2web.network
                        903-740-2549

                        Comment


                          #13
                          Re: Correct syntax for or statement in show/hide expression

                          Originally posted by mvaughn View Post
                          I have a similar situation here that is not working.
                          Show/Hide Expression for Frame:

                          Code:
                          Field1 = Textbox1 and Field2 = Textbox2 and Field3 = Textbox3
                          I keep getting a syntax error. Where is it?
                          1. Is this server side or client side?
                          2. Is this a grid or a dialog?
                          3. What are Field & Textbox?
                          4. What is the error message?
                          Alpha Anywhere latest pre-release

                          Comment


                            #14
                            Re: Correct syntax for or statement in show/hide expression

                            Thank you Sarah, as always I so appreciate your help.
                            I solved the syntax error. What I really need most is this:

                            Using the Action Script "Populate A Dialog From A Table" I have this in afterDialogValidate:

                            Code:
                            dim searchFilter as C = e.datasubmitted.KEYWORD + "|||" + e.datasubmitted.GRADESEARCH + "|||" + e.datasubmitted.SALARY
                            ExecuteServerSideAction("Populate Dialog from Tables::Populate_a_Dialog_with_data_from_one_or_more_tables")
                            Problem is: Only the first variable is passed to Populate as in this WHERE statement:
                            WHERE JOBTITLE = :ONETOMANY_LINKFIELD_jobcat_kwd_keyword

                            Question: How do I get all three passed to the WHERE?
                            Rapid Development, Training, Support
                            http://data2web.network
                            903-740-2549

                            Comment


                              #15
                              Re: Correct syntax for or statement in show/hide expression

                              The primary key value(s) used in the generated WHERE clause come from, I believe, the primary key defined in the data binding portion of the dialog. I think you might need to specify GRADESEARCH and SALARY as primary keys in the data binding section to make it work the way you want. But I'm not 100% sure that's the solution. You might want to start a new thread.
                              Alpha Anywhere latest pre-release

                              Comment

                              Working...
                              X