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

before upgrading to V9

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

    before upgrading to V9

    I'm still interested in the question that I posted with no answer yet.
    Is it possible to refresh and see new data in a form or a browse of an active link table without closing them and re-openning.?

    If you have a calculated field on a form that shoud consider all records that are being added to MySql database, is there anyway to reflect this on a form that is being viewed without exiting ?

    Thanks

    #2
    Re: before upgrading to V9

    What have you learned during your work with the beta? Are you still talking about an SQL database that's growing at the rate of 15 to 20 records per second, or faster? What do you mean "refresh and see new data"? The last 1000 entered, once a minute? Do the vcr record navigation buttons take you to a new last record if you wait a while for new records to be entered into the SQL table?

    Comment


      #3
      Re: before upgrading to V9

      Yes that's part of the issue, if you press vcr you don't see the records that were added to SQL since we first opened the browse.

      a simple example is when you have a form that has a quantity field for an account, and orders are coming in for that account, how do you see the quantity field reflecting the total for any records that came in after you opened that form ? F5 doesn't do it

      Comment


        #4
        Re: before upgrading to V9

        Anis, I think I know what you mean. I did a little experiment with build 1369_3159 (I believe the latest) using a simple active linked table against a MySql database. The A5 active link and the MySql table share all the same columns/fields.

        I have an auto increment field as the first field in the table.

        Upon opening the link in A5 I see all the records in the table. In this case I had three.

        I then went to the MySql command line and inserted record number four.

        I went back to the still open A5 browse or form and could find no way to see the added record. Refresh, resynch, nada. Even adding a new record from the A5 browse/form will only show the newly added (from A5) record. In other words the A5 browse now show records 1,2,3,5. Record 4 that was added using the MySql command line is no where to be found. I then added for more inserts from the MySql command line and returned to A5 and added one more from there. Now A5 shows records 1,2,3,5,9. A select * from statement run at the MySql command line shows all the records as I would expect.

        This all refers to the desktop only. I haven't tried with the WAS.

        So... I guess the question is can you use A5V9 in a mixed environment? From what I'm seeing A5 will only work correctly if it is the only source of the transactions.

        Want to have some real fun delete some records from the MySql command line and then try to edit them in A5 from an open form that will still show the records as existing. I ended up with a new record being created with only the data that was changed in the record.

        Since I have no way of testing V9 with more than one user on the same A5 database I have to assume that the problem I'm seeing in the mixed environment does not exist when A5 is handling all of the transactions and the active linked tables will behave like native DBF tables.
        Jim Coltz
        Alpha Custom Database Solutions, LLC
        A5CustomSolutions.com
        [email protected]

        Comment


          #5
          Re: before upgrading to V9

          This is exactly what I'm talking about Jim.
          The WAS works fine, because I have been working with it on V8 and didn't have a problem, because this feature actually exists.

          I'm just wondering if this will be possible in the future.

          Comment


            #6
            Re: before upgrading to V9

            Updates to the tables via MySql are also strange. If the record that you are updating via MySql happens to be the same record in A5 with a field highlighted in the A5 browse, a refresh of the A5 browse will show the updated record. Any other updates made via MySql on the table are not shown when the A5 browse is refreshed unless you move the highlighting to a field in the record that was updated.

            I'm not sure if this is a bug, "feature", or shortcoming. Hopefully Selwyn can shed some light on this.
            Last edited by Jim Coltz; March 15, 2008, 09:58 PM.
            Jim Coltz
            Alpha Custom Database Solutions, LLC
            A5CustomSolutions.com
            [email protected]

            Comment


              #7
              Re: before upgrading to V9

              Originally posted by Anis View Post
              I'm still interested in the question that I posted with no answer yet.
              Is it possible to refresh and see new data in a form or a browse of an active link table without closing them and re-openning.?

              If you have a calculated field on a form that shoud consider all records that are being added to MySql database, is there anyway to reflect this on a form that is being viewed without exiting ?

              Thanks
              When you open an active link table it does a query on the backend to get the count of the records in the backend table at the time the table is opened.

              every time you execute a new server side query, the count query is re-executed.

              so by issuing a server side query that returned all records, you would force the active link to reexecute the count query on the server.

              a query that returns all records could be:
              1=1

              so, to answery the question, just execute a server side query of 1=1 and the count query will get re-executed.

              Comment


                #8
                Re: before upgrading to V9

                Thanks Selwyn, so I could have a server side query script that runs on a timer of a form and that should update the records to match the sql records ?

                Comment


                  #9
                  Re: before upgrading to V9

                  Anis,

                  Did Selwyn's query suggestion make it refresh in the manner you wanted?

                  ba

                  Comment


                    #10
                    Re: before upgrading to V9

                    I have to find out how to write a script to run a server side query, I'm not sure how to do that yet.
                    That's the next step.

                    Comment


                      #11
                      Re: before upgrading to V9

                      Originally posted by Anis View Post
                      I have to find out how to write a script to run a server side query, I'm not sure how to do that yet.
                      That's the next step.
                      This code will run the query on the server for the parent table. For browses based on child tables on forms insert the proper slot number in table.current() or use table.get().


                      Code:
                      query.filter = "1=1"
                      query.order = ""
                      query.options = "S"  'run query on server option, see help files for query_create()
                      
                      table.current().query_create()
                      Jim Coltz
                      Alpha Custom Database Solutions, LLC
                      A5CustomSolutions.com
                      [email protected]

                      Comment


                        #12
                        Re: before upgrading to V9

                        Thanks Jim;
                        That actually worked, I put a button on the form and everytime I pressed it it updated the number of records that show at the bottom.

                        Next I added the script to a timer of 60 seconds and in fact it did update the number of records every minute.

                        Thanks for everyone's help and special thanks to Selwyn.

                        Comment


                          #13
                          Re: before upgrading to V9

                          Originally posted by Anis View Post
                          Thanks Jim;
                          That actually worked, I put a button on the form and everytime I pressed it it updated the number of records that show at the bottom.

                          Next I added the script to a timer of 60 seconds and in fact it did update the number of records every minute.

                          Thanks for everyone's help and special thanks to Selwyn.
                          we just added a new method for forms and browses:

                          <layout>.ServerSideRefreshAll()

                          this will re-execute the query for the active-link table that the form or browse is based on.

                          so if you have a button on a form:

                          topparent.ServerSideRefreshAll()

                          this would refresh all rows in the form's active-link table, and any rows added to the serve side table AFTER the form was originally opened, would not be visible to the form.

                          Comment


                            #14
                            Re: before upgrading to V9

                            That's great.
                            So if we have a calculated field on the form this should update that with new records from the server.

                            Comment

                            Working...
                            X