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?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---