Alpha Video Training
Results 1 to 7 of 7

Thread: Mapped Tables vs. Sets (Selwyn, can you explain?)

  1. #1
    Member
    Real Name
    jon larson
    Join Date
    Feb 2008
    Posts
    295

    Default Mapped Tables vs. Sets (Selwyn, can you explain?)

    In the attached example, there are four "tables" (two standard tables, one set linking those two tables, and one - new in V9 - mapped table linking those two standard tables).

    The form "single" displays an embedded browse of one of the standard tables. It has a separately-placed field also displaying value from column 1. When clicking from row-to-row on the browse, the separately-placed field updates (follows) as expected. Good.

    The form "set" displays an embedded browse of the set linking the two standard tables. It has a separately-placed field also displaying value from column 1. When clicking from row-to-row on the browse, the separately-placed field updates (follows) as expected. Also Good.

    The form "mapped" displays an embedded browse of the mapped table linking the two standard tables. It has a separately-placed field also displaying value from column 1. When clicking from row-to-row on the browse, the separately-placed field DOES NOT update (follow) as expected. BAD.

    Is this behavior (aka: lack of functionality) by design? Or am I missing something?

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

    Default Re: Mapped Tables vs. Sets (Selwyn, can you explain?)

    Quote Originally Posted by fsi View Post
    In the attached example, there are four "tables" (two standard tables, one set linking those two tables, and one - new in V9 - mapped table linking those two standard tables).

    The form "single" displays an embedded browse of one of the standard tables. It has a separately-placed field also displaying value from column 1. When clicking from row-to-row on the browse, the separately-placed field updates (follows) as expected. Good.

    The form "set" displays an embedded browse of the set linking the two standard tables. It has a separately-placed field also displaying value from column 1. When clicking from row-to-row on the browse, the separately-placed field updates (follows) as expected. Also Good.

    The form "mapped" displays an embedded browse of the mapped table linking the two standard tables. It has a separately-placed field also displaying value from column 1. When clicking from row-to-row on the browse, the separately-placed field DOES NOT update (follow) as expected. BAD.

    Is this behavior (aka: lack of functionality) by design? Or am I missing something?

    not sure what the bug report is because your attachment does not have forms in it.

    mapped tables are not replacements for sets.

    they are intended to solve an entirely different set of objectives (as explained in the what's new in v9 document.

  3. #3
    Member
    Real Name
    jon larson
    Join Date
    Feb 2008
    Posts
    295

    Default Re: Mapped Tables vs. Sets (Selwyn, can you explain?)

    From what's new:

    "You can create Forms, Reports, Labels, Letters and Operations for mapped tables just as you would for physical tables."

    My 3 forms, each of which includes an embedded browse (where the browse is bound to either a single standard table or set or Mapped Table) certainly seem to be created essentially identically with respect to standard table vs. mapped table. The What's New entry seems to suggest the browse functionality should work the same for Mapped Tables as it does for a standard table. But I'm not seeing that happen (as explained in first post).

    I'm not sure why you see no forms in my upload. I've rezipped the database & all files and attached here.

    Clicking from row to row on the browse bound to the single table does cause an update to the separately-placed field displaying column one cell contents.

    Clicking from row to row on the browse bound to the mapped table does not cause an update.

    Perhaps I misunderstand the What's New entry? Shouldn't the Mapped Table example work?

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

    Default Re: Mapped Tables vs. Sets (Selwyn, can you explain?)

    Quote Originally Posted by fsi View Post
    From what's new:

    "You can create Forms, Reports, Labels, Letters and Operations for mapped tables just as you would for physical tables."

    My 3 forms, each of which includes an embedded browse (where the browse is bound to either a single standard table or set or Mapped Table) certainly seem to be created essentially identically with respect to standard table vs. mapped table. The What's New entry seems to suggest the browse functionality should work the same for Mapped Tables as it does for a standard table. But I'm not seeing that happen (as explained in first post).

    I'm not sure why you see no forms in my upload. I've rezipped the database & all files and attached here.

    Clicking from row to row on the browse bound to the single table does cause an update to the separately-placed field displaying column one cell contents.

    Clicking from row to row on the browse bound to the mapped table does not cause an update.

    Perhaps I misunderstand the What's New entry? Shouldn't the Mapped Table example work?

    here is what i see in the control panel of your sample database. (no forms)

  5. #5
    "Certified" Alphaholic
    Real Name
    Bill Griffin
    Join Date
    Jul 2001
    Location
    Edgewood, NY
    Posts
    1,201

    Default Re: Mapped Tables vs. Sets (Selwyn, can you explain?)

    Selwyn,

    I can confirm that I am seeing what Jon is explaining. (different than your doc file) You appear to be in the wrong folder. It should be unzipping to MappedTable, not Mapped_Tables.

    Bill

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

    Default Re: Mapped Tables vs. Sets (Selwyn, can you explain?)

    Quote Originally Posted by fsi View Post
    In the attached example, there are four "tables" (two standard tables, one set linking those two tables, and one - new in V9 - mapped table linking those two standard tables).

    The form "single" displays an embedded browse of one of the standard tables. It has a separately-placed field also displaying value from column 1. When clicking from row-to-row on the browse, the separately-placed field updates (follows) as expected. Good.

    The form "set" displays an embedded browse of the set linking the two standard tables. It has a separately-placed field also displaying value from column 1. When clicking from row-to-row on the browse, the separately-placed field updates (follows) as expected. Also Good.

    The form "mapped" displays an embedded browse of the mapped table linking the two standard tables. It has a separately-placed field also displaying value from column 1. When clicking from row-to-row on the browse, the separately-placed field DOES NOT update (follow) as expected. BAD.

    Is this behavior (aka: lack of functionality) by design? Or am I missing something?
    i can duplicate it.
    it is a bug. we will fix it.

  7. #7
    "Certified" Alphaholic
    Real Name
    Bill Griffin
    Join Date
    Jul 2001
    Location
    Edgewood, NY
    Posts
    1,201

    Default Re: Mapped Tables vs. Sets (Selwyn, can you explain?)

    Great news. Thanks

Similar Threads

  1. How Mapped Tables differ from a set
    By Richard Rabins in forum Alpha Five Version 9 - Desktop Applications
    Replies: 2
    Last Post: 03-21-2008, 09:42 AM
  2. Mapped Tables
    By rleunis in forum Alpha Five Version 9 - Desktop Applications
    Replies: 1
    Last Post: 03-07-2008, 09:57 AM
  3. Renaming tables and sets
    By dodgebros in forum Alpha Five Version 7
    Replies: 11
    Last Post: 05-29-2007, 12:38 AM
  4. Update tables/sets etc.
    By Roger Adams in forum Alpha Five Version 4
    Replies: 0
    Last Post: 03-20-2003, 07:24 AM
  5. Ghosted tables/sets
    By Jeff Snyder in forum Alpha Five Version 4
    Replies: 3
    Last Post: 10-18-2000, 09:53 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
  •