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

Calculated fields (form) problems ...

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

    Calculated fields (form) problems ...

    I have some calculated fields that where working just fine from V6 to V7 and know in V8, they are not. Looks like some changes where made to screen that allows calculated values to be defined. There is this smart promting to explicitedly define "VAR->", or the "TABLE->", or "CALC->" ..... but this is not synching up with expression builder that allows for much more like using form object values. I went into expression builder and my expression works just fine ..... come out to calc value screen and it says it cant find field.

    I attached screenshot of expression builder showing ok and calc screen saying no good.

    Any help would be much appreciated ....

    Glenn

    #2
    Re: Calculated fields (form) problems ...

    I can reproduce the problem, and I am working on a fix.

    interestingly, it seems to allow function calls - i.e.

    customer_id_lbl.value

    fails

    customer_id_lbl.name()

    works (though appears to return a blank string)

    Also - eval doesn't appear to have a problem:

    eval("customer_id.value","topparent.this")

    except for the fact that it returns a blank.

    The calculated field editor takes over the parsers handling of field tokens (so that new calculated fields that were just defined can be used) , so it probably is that case that there is an error in this code when it encounters something that looks like a field from the parser standpoint, but in fact is *not* a field (i.e. object properties are not treated as fields).

    Comment


      #3
      Re: Calculated fields (form) problems ...

      This has now fixed, and should be in the next patch.

      Comment


        #4
        Re: Calculated fields (form) problems ...

        Cian ..... Thanks!!! .... (i sent this in to alpha bug address as well)

        The million dollar question ...... when do you think fix will be available .... this stops me in my tracks from upgrading my app from v7 to v8.

        Thanks again in advance ....

        Glenn

        Comment


          #5
          Re: Calculated fields (form) problems ...

          The V8 DLL that contains the is in the zip file attachment - it should work if overlaid on top of the latest patch beta (available at http://downloads.alphasoftware.com/a...hdownload.htm).

          After installing the patch, you must copy this file over the a5iutil.dll in the a5v8 executable path (making sure that alpha five is not running when you do this).

          This change should be included in the subsequent patch, once I let selwyn know its been fixed.

          Comment


            #6
            Re: Calculated fields (form) problems ...

            Still issues with Calc fields .....

            Cian .... thanks for the fix ..... got me past the use of object values in my calc field. Problem now is that is takes about 15-20 seconds to open calc value screen and every cursor movement through the calc field it tries to re-calc and takes yet another 20 seconds. This form came from V6 to V7 to now V8 ..... have not done alot of design in V7, but this exact calc scenario opens in a split second in V6 and does not give me any problems as i cursor through the name of the calc field. My screen shot show the calc field "owner_balance" and you should be able to see that im using extensive use of tablesum. Let me know if you cant re-produce and I will try to cut out of my application and send. Thanks!!

            Glenn

            Comment


              #7
              Re: Calculated fields (form) problems ...

              Cian .... attached a screen shot which show the status bar having issues with re-calc as well .... gets up to 99% and the just stays displayed even though calc is done.

              Comment


                #8
                Re: Calculated fields (form) problems ...

                Hi Glenn,

                The slowness you are experiencing has been fixed as well - a form whose calc fields load with errors - i.e. for instance when objects or fields named don't yet exists, would retry evaluation in v8 - this has been fixed so that if evaluation fails once during a bulk operation (i.e. load calc fields or enumerate calc fields) it doesn't keep re-evaluating code that already failed.

                There was a thread covering this issue (slow form loading in v8 or something like that..) - This change took load time from 15 seconds to 0.5 seconds...

                Comment


                  #9
                  Re: Calculated fields (form) problems ...

                  Cian,
                  I did see that thread, but didnt think it applied because it was dealing with validating invalid calc-fields. I downloaded the latest beta patch release and have applied the zip you sent me .... doesnt look like that fix is on this beta patch .... can you confirm?

                  Glenn

                  Comment


                    #10
                    Re: Calculated fields (form) problems ...

                    The slowness issue was was fixed around 4pm yesterday, the patch was built around 2pm, so the patch that was released doesn't have the calc-field-load-time fix in it.

                    Comment


                      #11
                      Re: Calculated fields (form) problems ...

                      Thanks Cian!!

                      Comment


                        #12
                        Re: Calculated fields (form) problems ...

                        Cian,
                        I put the latest (3057) beta patch on and even though it fixed valdation problem it hasnt fixed the problem of re-calcing as i move through the character positions of my calc field. The calc field in question is shown in the screenshot as "owner_balance" ..... when i cursor to begining of the line alpha re-calcs for about 20 seconds .... i move cursor over one character and it re-calcs again for 20 second ..... again and again until i get to where i need to get in the line. I could imagine if i had to work with multiple calc fields like this, I would pull out every hair in my head. This problem did not exist in V6 and hopefully you will be able to remedy. Please let me know if there is anything else I can provide you to help debug.

                        Thanks again .....

                        Glenn

                        Comment


                          #13
                          Re: Calculated fields (form) problems ...

                          Ok, I will take a look at this. I almost wonder if there is some recursion going on because the single-line calc field validation only visits the fields that are actually referenced.

                          Thanks,
                          Cian

                          Comment


                            #14
                            Re: Calculated fields (form) problems ...

                            Glenn,

                            Regarding the slowness of calculated field evaluation, can you please send me your application so that I can profile it, and find the bottleneck in validate?

                            Thanks,
                            Cian

                            Comment


                              #15
                              Re: Calculated fields (form) problems ...

                              Cian,
                              No problem, but to profile correctly you will need full data ..... I reduced app as much as I can, but with data the backup is still around 5M .....where can I send or ftp to?

                              Glenn

                              Comment

                              Working...
                              X