The ORM Foundation

Get the facts!

Search

Page 3 of 6 (60 items) < Previous 1 2 3 4 5 Next > ... Last »
  • Re: New data types for NORMA

    This all guesswork on my part, but, It should be easy to add in new data types in the style sheets.&nbsp; I don&#39;t think anything is hard coded.&nbsp; But mapping the data types from orm to sql is the trickey part.&nbsp; There has to be a type in orm that corresponds to the new data types in the database model you want to generate.&nbsp; So you ...
    Posted to Open Discussion & Feature Requests (Forum) by mnnoon on Fri, Feb 1 2013
  • Re: Do joins make the most sense when determining states.

    Sorry about that.&nbsp; I changed it marcnoon@userlevelup.com&nbsp;.&nbsp; New domain. I&#39;m fixing my profile now. &nbsp;Anyway... here is a quick example of what i was talking about. Given 4 state priorities...&nbsp; Jurisdiction State Claimant&#39;s State Employer&#39;s State Client State So its possible to have a state list ...
    Posted to ORM Techniques (Forum) by mnnoon on Thu, Jan 31 2013
  • Re: Do joins make the most sense when determining states.

    Yes I did use the brown book steps initially.&nbsp; But I was coming in mid stream so to speak and could not change the design requirements.&nbsp; But in workers comp we have Jurisdiction State which always comes first.&nbsp; Then we have the Claimant&#39;s State which is next, then we have the Claimant&#39;s employer&#39;s state, and finally we ...
    Posted to ORM Techniques (Forum) by mnnoon on Wed, Jan 30 2013
  • Re: Do joins make the most sense when determining states.

    This is what I discovered about condensing state codes into a single state. Ensure the state or country code exists in your list. Standardize the width of the codes to a single width If the state or country code is not in the list or null make is equal empty string &quot;&quot;. Do steps 1 through 3 for all codes in the interested ...
    Posted to ORM Techniques (Forum) by mnnoon on Tue, Jan 29 2013
  • Notes feature requests

    Hi, I use the notes feature quite a bit and would like to see the Model Note Connector point to a specific role, a junction between a role and a role connector, a manatory constraint, or any of the uniqueness constraints.&nbsp; The reason is because its a good way to describe to a Shmeeeee (SME) what going on. Also I would like to&nbsp;use the ...
    Posted to Open Discussion & Feature Requests (Forum) by mnnoon on Wed, Jun 13 2012
  • Re: Do joins make the most sense when determining states.

    The answer is no, no you should not use a case statement here. ;)
    Posted to ORM Techniques (Forum) by mnnoon on Mon, Jul 11 2011
  • Do joins make the most sense when determining states.

    Hi,&nbsp; I&#39;ve been trying to put joins into a case statement in SQL.&nbsp; The current version of SQL code has&nbsp;joins between a state rates table and several other tables that have states in them.&nbsp; But since there is an agreed upon order to how these rates are applied applied depending on which state a table is from, I have been ...
    Posted to ORM Techniques (Forum) by mnnoon on Wed, Jul 6 2011
  • Re: Nulls and Foreign key relationships

    You know what... this is almost a moot point after thinking about it.&nbsp; Because only if its a 1 to 1 relationship it won&#39;t be a problem&nbsp;&nbsp; Because if a sub table doesn&#39;t exist yet it can&#39;t have a value assigned to&nbsp;its foreign key relationship for&nbsp;its parent table&nbsp;anyways.&nbsp;&nbsp;&nbsp;Back to the grind ...
    Posted to ORM Techniques (Forum) by mnnoon on Fri, Jun 24 2011
  • Re: Nulls and Foreign key relationships

    The reason is to standardize the way things are done.&nbsp; I can see this being done on a value type, but on foreign key relationships, it seems strange.&nbsp;&nbsp; But the database is relaxed which makes it possible and requires extra steps due to the fact that their should be the database keeping track of these enforcements.
    Posted to ORM Techniques (Forum) by mnnoon on Fri, Jun 24 2011
  • Nulls and Foreign key relationships

    Quick questions on Nulls and foreign key relationship.&nbsp; I&#39;ve currently been asked to default all fields and even foreign key relationships to some default value.&nbsp; Even on left outer joins between rows that may not exist yet we have to set default values types&nbsp;using the isnull feature.&nbsp;&nbsp; My question is this, if a table ...
    Posted to ORM Techniques (Forum) by mnnoon on Fri, Jun 24 2011
Page 3 of 6 (60 items) < Previous 1 2 3 4 5 Next > ... Last »
© 2008-2020 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service