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
Devcon 2020 Goes Virtual! LEARN MORE >

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

Missing records

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    Missing records

    The application I am working with is currently running over a network and we have begun to experience the occassion disappearing act.

    It seems that saved records have disappeared from the database. The 3 instances of this happen has occured when using an embeded browse. Which contains a script that calls the record number and and open this record in a new form very basic I thought. The record missing seems to be the last record entered. There are currently 595 records in the table concerned, there should 598 at least. The user reported searching for and viewing the record both in an embedded browse and in a form. Latter in the same session the record was missing. I witness this occur once I think where the total last recno suddenly dropped by one.
    And as far as I can tell the missing records do not exist in the data base.

    The only problem I could find was that recno 1 was missing and the new test record I entered was recno 1 rather than 596 as I expected. But this might be normal if recno 1 is deleted for some reason? Is it normal?

    The users are runnin shadow if that is relevant.

    What might be going on here. How can I test to find the cause when I have no Idea as to what events actions such a disappearing act?

    Tim.
    Tags: None
    #2
    RE: Missing records

    Tim,

    Problems of this type have been discussed in several threads. The search facility of the forum will give you a number of things to check. Don't forget to search the A5V4 forum, as well.

    The physical record number for any specific record is not static. It will change when earlier records are deleted and the table is packed. It's often not a good idea to use the record number as a link field value in sets of related tables. For obvious reasons you want the link field value to remain unchanged when unrelated records are deleted. It's not clear to me whether this is your situation, but I thought I'd mention it. -- tom

    Comment

      #3
      RE: Missing records

      I've seen this happen where the user was using action scripting - they were creating a new child record, getting the record number, and then opening it in a separate form using zoom to. the problem was that the record pointer was incorrect.

      fix was
      1. enter the new child record
      2. before saving the new child record, get its record number
      3. save the child
      4. go to that record number in the child
      5. zoom to that record number
      Cole Custom Programming - Terrell, Texas
      972 524 8714
      [email protected]

      ____________________
      "A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB Shaw

      Comment

        #4
        RE: Missing records

        Martin,

        If it were me I'd save the new child record and then get its record number. Otherwise the sequence you describe is prudent.

        -- tom c

        Comment

          #5
          RE: Missing records

          Thanks Tom, I have not used the record number in linking so thats OK. I did previous spend some time in searhing the forum altough I did not try A5V4.

          Most of what I have found so far refers to display related issues. This is not the problem. The records in question definitely no longer exist in the DB on the server. As far as I can tell. I used show all then searched a defualt browse manually and using find comands.

          So far the only other similar occurance left bank fields in the table. This is not occuring for me. This thread sugested creating a code for keylogging to check what users are doing but I can figure out do that and easily obatin the results. I am not in the office were the app is used.

          Tim.

          Comment

            #6
            RE: Missing records

            Martin

            I have been thinking along those lines, but it is unlikely that I am dealing with saved child records. The record are par tof the set parent table. The embedded browse that is associated with theses losses (although not nessecarily the culprit) only shows up after a search query is completed and the user cannot enter or change records on this form. Further more the records that have disappeared did so after being being save and showing up and in one case acessed in the database atleast once by the user who entered them.

            I would like to try to duplicate all records users enter to conferm what records and when themy have gone missing. Is this best done as a post funtion from the table rules or script on the from?

            Tim.

            Comment

              #7
              RE: Missing records

              I'm confused about the forms and tables in your case.

              If your form is based on a set,
              and if you're losing primary (parent) table records,
              then your embedded browse must be based on the primary table.

              And, your called form would be based on the primary table alone (not a set of tables.)

              Is all of this correct?

              -- tom

              Comment

                #8
                RE: Missing records

                that is correct essentialy.

                however It does not matter now have discovered the fault. As usual its quite simple just a matter of finding it. The main data entry form has become corrupted in some way so it nolonger prevent changes in saved records. The user/s where typing over the previous entries thus accounting for the disappearing acts and the strange record numbering. I would recomend key logging for solving faults such as this. It also illustrates the importance of GUI set up and appropriately restricting users potential for damage.

                Thanks for you help tom and martin. Sorryit turned out to be so simple. But as usually talking this thing through helps

                Tim.

                Comment

                  #9
                  RE: Missing records

                  Yes, and it also illustrates another point (that I often overlook) the simplest explanation is often right. -- tom

                  Comment

                  Previous template Next
                  Working...
                  X