That is not a formulaCan you write something like this ? select yourfi...@yourfieldprefix from Something
2009/4/27 s_tristan <[email protected]> > > I have a property mapping when I need a dynamic SQL substitution: > > <property name='MyProperty' > formula='MyProperty:MyFilterDef.DynamicPrefix'/> > > And corresponding filter definition: > > <filter-def name='MyFilterDef'> > <filter-param name='DynamicPrefix' type='String'/> > </filter-def> > > Then I send this parameter to a session: > > string MyVar = "MyVar"; > session.EnableFilter("MyFilterDef").SetParameter("DynamicPrefix", > MyVar); > > But this does not work - parser does not recognize the filter > parameter, it sends SQL query like: > "... MyProperty:MyFilterDef.DynamicPrefix as Formula_0_1" > instead of: > "... MyPropertyMyVar as Formula_0_1" > > Is this an expected behaviour? If yes, how to workaroung this to send > this parameter to SQL query? > > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
