Alpha Video Training
Results 1 to 2 of 2

Thread: SEM How do you Clean Up?

  1. #1
    Bonnie Jacques
    Guest

    Default SEM How do you Clean Up?

    Each year in the spring I back up my files, and then I go and delete all the records in the databases. I noticed last year one of the DDD files was huge. This time the hours.sem file is 18,991 kb, is this a little big considering I deleted all the records?
    I would like to know if there is a way to clean up all the .dbf's and whatever is related to them, so I can start with a fresh uncluttered application.

  2. #2
    "Certified" Alphaholic Melvin Davidson's Avatar
    Real Name
    Melvin Davidson
    Join Date
    Apr 2000
    Location
    Parker, CO
    Posts
    1,197

    Default RE: SEM How do you Clean Up?

    Bonnie,

    A little background,
    Database files keep information about
    scripts, forms, rpts, etc. in files that
    end with

    .ddd, .ddm & .ddx

    Database "Sets" keep vital information
    in .set, .sem & .sex

    Likewise, apps keep inportant informatation
    in .apd, apm & apx

    You can easily reduce the size of the of most
    of these files by running MAINTENANCE.
    1. From the control panel, chose the APPS tab.
    2. Then left click the Maintenance button.
    3. Chose the appropriate file type you want
    to run against. Hint, run them all, one at
    a time.
    4. For the file name, leave the wild card and type
    eg: for database -> *.dbf
    and click to on the drop down to insure you are
    in the correct path for the file you need to shrink.
    5. Then just ! (do it!).
    Depending on how many files you have, the type and size
    it may be quick or a few minutes. Either way, you can
    note progress by viewing the progress meter on the bottom
    left of your screen.

    Regards,
    Melvin

Similar Threads

  1. Clean Startup How?
    By Claudio Pilustrelli in forum Alpha Five Version 5
    Replies: 5
    Last Post: 12-05-2003, 11:09 AM
  2. Clean Up Registry
    By scottly in forum Alpha Five Version 5
    Replies: 6
    Last Post: 11-02-2003, 03:27 AM
  3. How to get a clean screen
    By Greg Fong in forum Alpha Five Version 4
    Replies: 6
    Last Post: 11-29-2001, 11:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •