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

Dummy Tables

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

  • Dummy Tables

    I have a question? What is the purpose in some of the sample application that contain tables that are just "DUMMY TABLES". This may sound like a dumb question but just learning!

  • #2
    RE: Dummy Tables

    One of the main reasons but there must be many more. If you are running scripts that require your application tables to be closed such as index building, deleting $$ files you can run the script from a form based on the dummy table that contains no important data.

    Michael

    Comment


    • #3
      RE: Dummy Tables

      Bob, you can also use dummy tables to link misc forms to such as a main menu, utility screen and so on.
      Jeff

      Comment


      • #4
        RE: Dummy Tables

        I believe the usage of "Dummy" tables is wrong!!!!

        I prefer to think of them as "Database Usage challenged"

        Actually, though, I use to refer to them as DUMMY.DBF when using A4, but this often led to disaster as stupid...correction, "Intellectully Challenged" users would delete them thinking they were un-important (as in a Temporary DBF).

        Thus, since moving to A5, I have tended to call these tables things like APP.DBF, MAINMENU.DBF, MENU.DBF etc. I almost always create a one field table with 1 record (1 record takes care of some cases where a 0 record table may be treated a bit differently)

        The importance of these tables is that while you have them open, since they don't connect to any tables that have data in them, and have a minimal set of forms and similar associated with them, they do not lock up other tables for operation that require exclusive use. If you return to that table, form, etc when not performing other functions, you minimize corruptions to your real data tables in case of a workstation or network crash.

        In a similar fashion, I always create Temporary files with a name starting with TEMP so that the file is easy to find and to delete. When possible, place the Temp files in the user's private directory and delete when done with them. If they need to be shared with other users, then create it in the Master (ADB's) path of the database.

        Regards,

        Ira J. Perlow
        Computer Systems Design & Associates
        [email protected]
        Regards,

        Ira J. Perlow
        Computer Systems Design


        CSDA A5 Products
        New - Free CSDA DiagInfo - v1.39, 30 Apr 2013
        CSDA Barcode Functions

        CSDA Code Utility
        CSDA Screen Capture


        Comment


        • #5
          RE: Dummy Tables

          Ira,
          Not to wake up a sleeping dog, but if the user (who should never know what the table names are to begin with because the app was written using MAXIMIZED forms and access to the control panel does not exist), it would not matter to anyone but the programmer if the table was named dummy? I will always love you Ira, even when I oppose your posted views of such conviction! Opposition is a great way learn.
          Your friend always,
          Jeff

          Comment


          • #6
            RE: Dummy Tables

            Jeff,

            That would be true, IF, and only IF, Alpha was the only way of accessing your files. If you have dialog boxes that allow a file selection, then a user could potentially select any directory, including your database directory (which is often a default - bad, BAD choice) to say, export some data.

            One way is to set the default someplace else (My Documents is a good useless choice, remembering their last chosen directory is better - that's what I do) and disallow the choice of the database directory by comparing it to the A5.Get_path(), A5.get_master_path() and then making them go reselect it.

            And then there is something called DOS and Windows Explorer. When a user has only 50k free space and starts clearing out his hard disk, they just love to delete anything that looks unimportant to them. (We could turn this thread into a User-bashing thread, but I don't really want to go there.)

            Regards,

            Ira J. Perlow
            Computer Systems Design & Associates
            [email protected]
            Regards,

            Ira J. Perlow
            Computer Systems Design


            CSDA A5 Products
            New - Free CSDA DiagInfo - v1.39, 30 Apr 2013
            CSDA Barcode Functions

            CSDA Code Utility
            CSDA Screen Capture


            Comment


            • #7
              RE: Dummy Tables

              Hi Ira,

              I don't believe user bashing could be confined to a single thread. More likely it would need its own forum!

              Bill
              Bill Hanigsberg

              Comment


              • #8
                RE: Dummy Tables

                and disallow the choice of the database directory by comparing it to the A5.Get_path(), A5.get_master_path() and then making them go reselect it.

                I LOVE IT! Thanks Ira. I never thought of this before but it will definitely be used in the future.

                Cal

                Comment

                Working...
                X