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



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

Compact Corrupts

  • Filter
  • Time
  • Show
Clear All
new posts

  • Compact Corrupts

    V10 Build 2562-3504

    Designed a small new race car system Monday night. Copied a sample form from another system and deleted all fields.

    After adding the required fields and saving I ran the form.
    Got an error message indicating 69 errors (See trace window).

    The trace window indicated 69 fields in error. While they were not in the drop down list, the object explorer indicated the deleted fields from the third tab.

    ? how to delete.

    I choose to compact to clean up the form.


    Could not open form, table structure or field rules. Totally corrupt.

    Rebuilt system and same result.

    Took another production system (backed up first thankfully), same result.

    After checking the message board indicators pointed to Kaspersky 2010.

    Tried suggestion to exclude A5 from anti virus - same result.

    Totally disabled anti virus SAME result.

    Any thoughts that this build is to blame or ???????

    Thanks, John

  • #2
    Re: Compact Corrupts

    Copied a sample form from another system and deleted all fields.
    How did you do this?

    Assuming the source form was based on a table, did you add the table and its related files to application then right click the form in the Control Panel and "copy to"? If so, did you then open new form and delete all field related objects and then delete the unwanted table from application?


    • #3
      Re: Compact Corrupts


      Yes, that is what I did.



      • #4
        Re: Compact Corrupts

        You mention leftover fields on a tab control and how to delete. When you select a tab you can right click to "select all objects on tab pane" and then press delete. You must do this for every pane. As you know, you can then check the object explorer to confirm all unwanted fields are gone.
        Alternatively delete the tab control then add a new one.
        I think when all unwanted controls are gone that the Compact should work, but this is not based on first hand experience with the build you mention.


        • #5
          Re: Compact Corrupts

          I use the Object Explorer window to delete the objects in this situation. Highlight the object entry in the "Object name:" list. Click the "Select Object" button below the list. You should then see the black object selection squares appear on the form. Then I press the "delete" key on the keyboard to delete the object from the form.

          I have found this to be time consuming and cumbersome but only happens when a tabbed object is used.


          • #6
            Re: Compact Corrupts

            Thanks for the replies.

            However the main issue is that ANY compact I do on ANY application totally corrupts!



            • #7
              Re: Compact Corrupts


              I have seen this same EXACT thing. Reinstall the patch of the current version you are running(3504). This solved my problem. It seems Alpha itself somehow gets corrupted.




              • #8
                Re: Compact Corrupts


                Just tried re-loading V10 then 10.5.

                Setup a basic dbf & form.

                Compacted !!!!!! CORRUPT !!!!!!!

                See attached images

                Thanks, John


                • #9
                  Re: Compact Corrupts

                  Bummer John!

                  As I had mentioned I had this same issue. It drove me nuts for a day. Like you, I made a simple one table app with one form and would get the same messages you attached. I did not get the memo field error - but the other 2 were exactly the errors I got. After messing with it for awhile and right after I made the one table / form app and got the same "drop table" message - I was relieved to know the main app I was working on was not the issue. But, I had the issue nonetheless. I just reinstalled the patch of 10.5 I was running and the problem went away. Sorry to hear it didn't work for you. What version did you patch to? The most current or the 3504 you were running?




                  • #10
                    Re: Compact Corrupts


                    Went to the latest update 3040-3571.

                    No Joy.

                    Thanks for your efforts, John


                    • #11
                      Re: Compact Corrupts

                      John, I'm curious. Try compacting AlphaSports (after first creating a good backup of course). What happens?


                      • #12
                        Re: Compact Corrupts

                        "Control" seems like it might not be a good name for a table. Maybe that name is causing the problem. Have you tried changing it?

                        You also might want to try separating the table PACK action from the data dictionary COMPACT action. Alpha's Database Compact action does both at once. Try compacting the data dictionaries one at a time with the Dictionary.Update() function. Use the .DDD (not .dbf) and .SET extensions then do the .ALB file and see what happens. If this works successfully on all files then the problem you are encountering probably has to do with the actual packing and/or re-indexing of a table. Try packing those one at a time to see if that locates the problem for you.
                        Last edited by CALocklin; 08-06-2010, 12:41 PM.


                        • #13
                          Re: Compact Corrupts

                          Cal & Jeff

                          Thanks for the suggestions. I will try again.



                          • #14
                            Re: Compact Corrupts

                            Just thought I would follow up.
                            Sent a query to Kaspersky.
                            They suggested updating from 2010 to 2011.
                            Lo & behold, compact now works.

                            Thanks to all