A SP in a <formula> really is something very new for me.Btw in NH2.0.1 you must register the KeyWord 'EXEC' in your dialect. in NH2.1.0 the keyword should be there.
2009/7/1 Pete <peter.w.da...@gmail.com> > > Does anyone know if mapping a property to a stored procedure should > work? > > <id name="MyId" type=Guid"> > <generator class="assigned"/> > </id> > <property name="MyProperty" access="nosetter.camelcase" > formula="( EXEC MyStoredProc MyId )" /> > > The generated SQL is something like: > > SELECT > this_.MyId as xxxxxxxx > this_.EXEC this_.MyStoredProc this_.MyId as formula_0 > FROM MyTable this_ > > where i am trying to get: > > SELECT > this_.MyId as xxxxxxxx > EXEC MyStoredProc this_.MyId as formula_0 > FROM MyTable this_ > > I am trying to create a boolean readonly property that is populated by > a IF EXISTS (SELECT ... ) query to see if there are rows related to > this table in another table. > > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---