CodeSmith Community
Your Code. Your Way. Faster!

Tables without primary key default to View and VList

Latest post 05-19-2008 9:34 AM by SuperJeffe. 3 replies.
  • 05-14-2008 10:22 AM

    • EggleGray
    • Not Ranked
    • Joined on 04-04-2006
    • Posts 5
    • Points 145

    Tables without primary key default to View and VList

    I have several tables without primary key.

    When I click Generate it reports that

    Table AddressTransaction does not have a primary key, it will not be generated.
    Table AndonLog does not have a primary key, it will not be generated.

    It would be nice to fall back to creating a VList so I could at least do SELECT

    Is it possible to do this another way? 

     

    Gregg Teehan
    Filed under:
    • Post Points: 35
  • 05-14-2008 2:58 PM In reply to

    • SuperJeffe
    • Top 25 Contributor
    • Joined on 05-05-2006
    • Tulsa, Ok
    • Posts 342
    • Points 8,610

    Re: Tables without primary key default to View and VList

    I think you would have to create a view in order for Nettiers to be able to select from it.

    Not a bad idea to have it fallback to a View.  Not saying that it is easy to do but it is a pretty good idea.

    jeff

    ----------------------------------------------------------------------
     Member of the .NetTiers team | Visit http://www.nettiers.com
    ----------------------------------------------------------------------

    • Post Points: 35
  • 05-19-2008 8:13 AM In reply to

    • EggleGray
    • Not Ranked
    • Joined on 04-04-2006
    • Posts 5
    • Points 145

    Re: Tables without primary key default to View and VList

    I would like to contribute and this sounds like a worthy 1st effort.

    Where do I start?

    Is there a wiki or how-to on contributing code?

     

    Gregg Teehan
    • Post Points: 35
  • 05-19-2008 9:34 AM In reply to

    • SuperJeffe
    • Top 25 Contributor
    • Joined on 05-05-2006
    • Tulsa, Ok
    • Posts 342
    • Points 8,610

    Re: Tables without primary key default to View and VList

    I am not sure if there are a set of instructions anywhere or not.  You can find some posts on coding standards and what not if you search.

    What we typically do is we want people to provide patches.  I think this is a pretty good list of steps:

    1. Download the latest copy from SVN.
    2. Make all the changes to the templates required for your change
    3. Before creating patch, make sure you get the latest version from SVN so you create the patch with the latest templates.
    4. Ceate a patch and submit it to be tested and looked at by a Nettiers team member.

    jeff

    ----------------------------------------------------------------------
     Member of the .NetTiers team | Visit http://www.nettiers.com
    ----------------------------------------------------------------------

    • Post Points: 5
Page 1 of 1 (4 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems