Alpha Video Training
Results 1 to 4 of 4

Thread: Mapped Tables vs Sets (round II)

  1. #1
    Member Roderick's Avatar
    Real Name
    Roderick Silva
    Join Date
    Aug 2006
    Location
    Miami, FL
    Posts
    141

    Default Mapped Tables vs Sets (round II)

    Can someone briefly explain the advantages and disadvantages of using mapped tables over sets?


    *note*
    I started a new thread because the last one ended in a big fix.
    Thanks,

    Roderick Silva
    rodericksilva@gmail.com

    About Me: rodericksilva.com
    Twitter: rodericksilva

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,644

    Default Re: Mapped Tables vs Sets (round II)

    1.
    a - field rule lookups only use a table - (single or mapped)
    b - sets not allowed.

    2.
    a - Mapped tables can only be one to one ( invert parent child to get a many to one )
    b - Sets can be one to many

    3.
    a - Mapped tables can have a subset of the fields available - creating a classic 'view' of the data that can be controlled by user
    b - sets show all of the fields in it's table(s)

    Undoubtedly many more...

    and where is that last thread?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    Member Roderick's Avatar
    Real Name
    Roderick Silva
    Join Date
    Aug 2006
    Location
    Miami, FL
    Posts
    141

    Default Re: Mapped Tables vs Sets (round II)

    I appreciate you taking the time to write something up. Thanks.

    Quote Originally Posted by Al Buchholz View Post
    and where is that last thread?
    Mapped Tables vs Sets (original)
    Thanks,

    Roderick Silva
    rodericksilva@gmail.com

    About Me: rodericksilva.com
    Twitter: rodericksilva

  4. #4
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,644

    Default Re: Mapped Tables vs Sets (round II)

    Quote Originally Posted by Roderick View Post
    I appreciate you taking the time to write something up. Thanks.



    Mapped Tables vs Sets (original)

    Another link to additional information is this..
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. mapped tables
    By Bill Parker in forum Archived Wishlist
    Replies: 2
    Last Post: 05-22-2010, 08:49 AM
  2. Mapped Tables - Another Use
    By Steve Workings in forum Alpha Five Version 9 - Desktop Applications
    Replies: 0
    Last Post: 08-15-2008, 09:57 AM
  3. V9 Mapped Tables
    By KathyB in forum Alpha Five Version 9 - Desktop Applications
    Replies: 11
    Last Post: 06-24-2008, 11:30 AM
  4. Mapped Tables vs. Sets (Selwyn, can you explain?)
    By fsi in forum Alpha Five Version 9 - Desktop Applications
    Replies: 6
    Last Post: 04-07-2008, 04:29 PM
  5. Mapped Tables
    By rleunis in forum Alpha Five Version 9 - Desktop Applications
    Replies: 1
    Last Post: 03-07-2008, 09:57 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
  •