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

How would YOU do it ?

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

    How would YOU do it ?

    Suppose you had one database application that you needed/wanted to completely integrate into several other database applications you had.
    How would YOU do this?

    You could of course copy all tables, forms, reports etc from the one database into the other database, but that does not seem very elegant.

    Is there a more elegant, faster, more efficient, more structured way?

    What do YOU think? Is there? How?

    How would YOU do it?

    #2
    Re: How would YOU do it ?

    Main Folder
    |
    |-> Master Folder
    |-> Database 1 folder
    |-> Database 2 folder

    Master Folder folder holds the database that is shared across all the other databases
    Andrew

    Comment


      #3
      Re: How would YOU do it ?

      Hi Andrew, I can't see how this would make the functionality of your master folder database usable in your other databases?
      For instance, how would you connect a form with functionality from the master folder to the menu form of one of the other databases?
      This looks like just the organizational setup, or what do I miss?

      Comment


        #4
        Re: How would YOU do it ?

        You have to add the master database tables to the other databases.
        Andrew

        Comment


          #5
          Re: How would YOU do it ?

          Hi Andrew,

          Yes, that is an option, but then you get one "organic" database. I understand that option. But I am looking for a more "slick" solution for instance where the master database would function as an add-on to the other databases or something like that. So you will not "cloud" the transparency/organizational structure from the transaction databases (the others) with the complexity of the "master" database. The control panel of Alpha Five is severally limited with regards to the organisational structure as is, and I am looking for options to add complete databases to one database without making it even more complex in the control panel by added tables, forms and reports. I do not know if it even can be done....

          Comment


            #6
            Re: How would YOU do it ?

            Form.view()
            http://wiki.alphasoftware.com/FORM.VIEW+Method

            Form_Name Argument
            Code:
            The name of the form to open. In the case where there are duplicate form names in the database, you can qualify the form name with the table name 
            using this syntax: Form Name@Table Name. For example, if a database has a form called Customers for the Current_Customers and the Past_Customers tables, 
            you can specify the form as: Customers@Current_Customers, or Customers@Past_Customers.
            You can pass the table path in information in the Form_Name argument. I do not know if the argument will accept relative paths or only absolute paths.
            Code:
            form.view("insurance_frm@G:\A5Ver5\MasterIns\ins.dbf")
            Andrew

            Comment


              #7
              Re: How would YOU do it ?

              hello

              i was reading something else in alphapedia and came across this article.
              http://wiki.alphasoftware.com/Using+...se+Application

              take a look, is this something you are looking for?
              thanks for reading

              gandhi

              version 11 3381 - 4096
              mysql backend
              http://www.alphawebprogramming.blogspot.com
              [email protected]
              Skype:[email protected]
              1 914 924 5171

              Comment


                #8
                Re: How would YOU do it ?

                Hi Ghandi.

                That is indeed quite a different approach. However, it only involves codes and functions, not tables, forms and reports. So this will not work.
                I now there is also the function of using another Alpha Five database but that sets the master database alongside the transaction database so to say.
                What I am looking for is more that the master database would sit in a "subdirectory" of ANY transaction database so it does not get mixed up with the tables and forms of the transaction database but still can do its job.

                Comment


                  #9
                  Re: How would YOU do it ?

                  Without overthinking this - the key elements you mention lead me to suggest this method
                  You haven't mentioned code and UDFs so that is not your immediate focus - requires different migration methods.
                  Zip each master set, that will include all that is needed to resurrect the tables, forms, reports etc into another database.
                  In the other database, after unzipping, add the set.
                  If doing this repetively, construct code to perform most if not all of it

                  Comment


                    #10
                    Re: How would YOU do it ?

                    Hi Ray, thanks for your contribution here!
                    I understand that is how it can be done, it was suggested already in this thread. Zipping and unzipping, adding tables etc to the database all ends up in ALL tables, forms, reports etc etc being in just the one large database. That is what I would like to prevent.

                    What I try to achieve is the following end situation:

                    DB1 Transaction Database
                    |
                    |----> DB2 Master Database

                    Where DB2 would be fully functional within DB1 (with a button on a form of DB1 you could open a form, report, etc in DB2).
                    Where DB1 and DB2 would have their own control panel with only their own tables, forms and reports visible.

                    Sort of like a subdirectory so to say, but inter connected.

                    Comment


                      #11
                      Re: How would YOU do it ?

                      That button would have to switch databases. Quite possible.
                      Then you are back to the namespace issue if you want to establish communication between.

                      Comment


                        #12
                        Re: How would YOU do it ?

                        Originally posted by mronck View Post
                        Hi Ray, thanks for your contribution here!
                        I understand that is how it can be done, it was suggested already in this thread. Zipping and unzipping, adding tables etc to the database all ends up in ALL tables, forms, reports etc etc being in just the one large database. That is what I would like to prevent.

                        What I try to achieve is the following end situation:

                        DB1 Transaction Database
                        |
                        |----> DB2 Master Database

                        Where DB2 would be fully functional within DB1 (with a button on a form of DB1 you could open a form, report, etc in DB2).
                        Where DB1 and DB2 would have their own control panel with only their own tables, forms and reports visible.

                        Sort of like a subdirectory so to say, but inter connected.
                        I provided a sample of code earlier that would allow you to open a form bound to a table that was not part of the current database. Did that not work for you?
                        Andrew

                        Comment


                          #13
                          Re: How would YOU do it ?

                          I think Marcel wishes to keep forms and tables from the other Db out of the current one.
                          I know of nothing other than silently switching databases.
                          And then I remember the problems that caused in a previous huge heated thread. I will find it if anyone has interest.
                          Meanwhile Marcel appears to have left the building or started Christmas early.

                          Comment


                            #14
                            Re: How would YOU do it ?

                            Originally posted by Ray in Capetown View Post
                            I think Marcel wishes to keep forms and tables from the other Db out of the current one.
                            Aye, that code is how you open a form that is not in the current database.
                            Andrew

                            Comment


                              #15
                              Re: How would YOU do it ?

                              For me this doesn't open a form that is not in the current database
                              Code:
                              form.view("Cust@c:\drive_g\acdps\cust.dbf")
                              ERROR: Not found
                              where it is in another. Would be an interesting idea - can you explain how you have it working

                              Besides why are we bothering when Marcel Onck is not.

                              Comment

                              Working...
                              X