Alpha Video Training
Results 1 to 2 of 2

Thread: How to Attach Database Files to a Message

  1. #1
    Alpha Software Employee Selwyn Rabins's Avatar
    Real Name
    Selwyn Rabins
    Join Date
    Mar 2000
    Location
    Boston, MA
    Posts
    5,298

    Default How to Attach Database Files to a Message










    How to Send Alpha Five Files to Demonstrate a
    Problem




    Often it is easier to demonstrate a problem you are
    having with Alpha Five with real data that it is to describe it in words.

    Note: This document applies to Alpha Five Version 2,
    3 and 4. The Alpha Software message board allows
    you to attach a file, up to 1 MB in size, to your message.
    Since an Alpha Five
    application typically involves a lot of different files, knowing which files to
    attach to your message can be quite tricky. Also, since you can only attach a
    single file to the message, you must Zip up your files into a single zip file
    that is less than 1 MB.
    Note: If you don't have
    WinZip, you can download a copy from www.shareware.com.
    This document describes how to attach a file to your
    message.
    1. Make a new temporary folder
    on your computer.
    2. Copy the database files to
    the temporary folder. The database files have the extensions: .adb .alm .alx
    .alb. For example, if your database is called "Invoices", copy the
    files "invoices.adb", "invoices.alm",
    "invoices.alx" and "invoices.alb" to the temporary folder.

    3. Copy the minimum set of
    files necessary to duplicate the problem to the temporary folder. For example,
    if your problem involves just a single table, called "Customer" for
    example, then copy:

    "customer.dbf",
    "customer.fpt",
    "customer.cdx",
    "customer.ddd",
    "customer.ddm" and
    "customer.ddx"

    to the temporary folder.

    Note: If the table does not have memo fields the
    .fpt file will not exist.
    If the table has no indexes, the .cdx file will not exist.

    4. If your problem involves a set, copy all of the tables in the set (.dbf,
    .fpt, .cdx, .ddd, .ddm and .ddx extensions) and the set itself (.set , .sem and
    .sex extension) to the temporary folder.

    For example, say you have a set called "Orders" which has two tables,
    "Header" and "Items", you would need to copy the following
    files to the temporary folder:

    Orders.set
    Orders.sex
    Orders.sem
    Header.dbf
    Header.fpt
    Header.cdx
    Header.ddd
    Header.ddm
    Header.ddx
    Items.dbf
    Items.fpt
    Items.cdx
    Items.ddd
    Items.ddm
    Items.ddx

    5. Start Alpha Five and open the database in the temporary
    folder.

    6. If possible, delete unnecessary records in any tables to make them smaller.


    For example, if you have a table with 100,000 records, and you can demonstrate
    the problem with just 10 records in that table, delete the unnecessary records,
    and then Pack the table.

    7. CONFIRM THAT YOU CAN STILL DUPLICATE THE PROBLEM USING THE DATABASE IN THE
    TEMPORARY FOLDER.

    8. Exit Alpha Five and use WinZip to zip up all of the file in the temporary
    folder.

    9. Create a new message on the message board. Describe in detail how to
    duplicate the problem. For example:

    Open "FormA"
    Enter a new record.
    Give focus to the "Lastname" field. Etc.



    10. Attach the zip file to the message.






  2. #2
    Douglas Kaya
    Guest

    Default RE: How to Attach Database Files to a Message

    Hi Selwyn !!!

    Congrat's on a GREAT Board !

    Your "tip": How to Attach Database Files to a Message

    is a "Keeper" !

    Is there anyway it can become a "Permanent" post ?
    (Separate area or "always on top")

Similar Threads

  1. Expected Value error message on opening database
    By Bill Rogers in forum Alpha Five Version 5
    Replies: 1
    Last Post: 03-07-2004, 10:44 PM
  2. Confued by Database Compact error message ...
    By drgarytraub in forum Alpha Five Version 5
    Replies: 38
    Last Post: 01-11-2004, 02:22 PM
  3. SQL Attach MDB Files
    By Dennis Baggott in forum Alpha Five Version 5
    Replies: 0
    Last Post: 09-22-2003, 03:04 PM
  4. How do I attach a zip file to message
    By Jean-P. B├ędard in forum Alpha Five Version 4
    Replies: 3
    Last Post: 04-13-2001, 03:50 AM
  5. pRINTER DATABASE ERROR MESSAGE
    By Rokrz in forum Alpha Four Version 6 and Prior
    Replies: 2
    Last Post: 06-28-2000, 11:00 AM

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
  •