Strict Standards: Declaration of BB_Walker_Blank::start_lvl() should be compatible with BB_Walker::start_lvl($output) in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/classes.php on line 1127

Strict Standards: Declaration of BB_Walker_Blank::end_lvl() should be compatible with BB_Walker::end_lvl($output) in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/classes.php on line 1127

Strict Standards: Declaration of BB_Walker_Blank::start_el() should be compatible with BB_Walker::start_el($output) in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/classes.php on line 1127

Strict Standards: Declaration of BB_Walker_Blank::end_el() should be compatible with BB_Walker::end_el($output) in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/classes.php on line 1127

Strict Standards: Redefining already defined constructor for class bbdb in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/db-mysql.php on line 12
Questions About Using SynApp2 « Support Forums

Support Forums
Support Forums
» General Discussion


  1. Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 440

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 510

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 512
    richard

    Administrator

    from Mico...

    Now more questions about synapp2. If I follow the database field naming conventions outlined in synapp2.txt. Do you still need to use KeyMap?
    Will the program detect all the joins betwen tables and create the necessary forms?
    Which table do you pick for the basis table in the PageGen?
    Can I have a master single form that writes to all joined tables, instead of having a form per table? If YES, then how can you do that?
    Do you have any tutorial on using the application itself in a full scale complex database scenario?

    Posted 11 years ago #

  2. Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 440

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 510

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 512
    richard

    Administrator

    >> If I follow the database field naming conventions outlined in synapp2.txt. Do you still need to use KeyMap?

    No, you don't need KeyMap if you follow the naming conventions:

    - Primary Key: id
    - Foreign Key: id_tablename

    But, some useful tools like MySQL Workbench, use a similar, yet different convention. KeyMap is fast and easy to use, so it may make sense to follow a another naming convention and use KeyMap to define keys for SynApp2.

    You can mix the methods too. If it's convenient to name some key fields according to SynApp2 conventions and use the KeyMap for others, that will work. The KeyMap page will always reflect what SynApp2 knows about the keys, however you choose to declare them.

    No matter how you declare your keys, they all have to be numeric and automatically assigned by the database engine.

    Posted 11 years ago #

  3. Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 440

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 510

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 512
    richard

    Administrator

    >> Will the program detect all the joins betwen tables and create the necessary forms?

    Yes, if SynApp2 has been made aware of all the table keys, by naming convention and/or the KeyMap, all of the necessary forms will be generated and the referential integrity of the database will be correctly maintained.

    It is important to understand concepts of database normalization and to adhere to reasonable practices. SynApp2 is capable of dealing with 1-to-many and many-to-many relationships with ease. You, as the database designer, must know what you need in order to accomplish your objectives.

    Posted 11 years ago #

  4. Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 440

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 510

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 512
    richard

    Administrator

    >> Which table do you pick for the basis table in the PageGen?

    For most applications, you will use PageGen to generate a page for every table in your database. The basis table is the primary focus of a SynApp2 page. You will eventually pick every table as the basis table.

    For every basis table you pick and have PageGen create a page, you will see a corresponding navigation tab in the application. A report tab for basis table also gets created.

    You will find some more information about this in the SynApp2 Concepts document:
    http://www.synapp2.org/documentation/SynApp2_Concepts.pdf

    You can control which application tabs/pages/reports users will see and have authorized access to.

    Read about authorization in the SynApp2 Customization document:
    http://www.synapp2.org/documentation/SynApp2_Customization.pdf

    Posted 11 years ago #

  5. Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 440

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 510

    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /webroot/s/2/s2admin/synapp2.org/www/forum/bb-includes/kses.php on line 512
    richard

    Administrator

    >> Can I have a master single form that writes to all joined tables, instead of having a form per table? If YES, then how can you do that?

    You can have a single page that works with all of your joined tables.

    Normalized database designs often have a hierarchy somewhat like a tree. PageGen will display a representation of some or all of the tree, depending on your choice of basis table. You control how much of the tree (i.e. which tables), from the point of view of the basis table, should be reflected in the generated page. You do this by selecting (or not selecting) a tier table on any of the visible branches.

    Experiment. See what happens as you use PageGen to create pages with different tier table selections. Actually work with the generated pages to see how they react. There are some carefully thought out behaviors that address important details.

    Again, you'll find more information in the SynApp2 Concepts document.

    Posted 11 years ago #

RSS feed for this topic

RSS feed for this topic

Reply »

You must log in to post.