<p>Hi All,</p>
<p> </p>
<p> I need to dynamically change the query based on parameter. For that i am using replace text function in before open of Dataset.</p>
<p> I need to replace the following query </p>
<p> </p>
<p><span style="font-family:arial, sans-serif;font-size:small;">" <span style="color:#0000ff;">Union SELECT * FROM Table_Name sd</span></span></p>
<div style="font-family:arial, sans-serif;font-size:small;"><span style="color:#0000ff;">WHERE sd.datefield BETWEEN </span></div>
<div style="font-family:arial, sans-serif;font-size:small;"><span style="color:#0000ff;">date_sub((STR_TO_DATE</span><span style="color:#000080;">( </span><span style="color:#ff0000;">" </span><span style="color:#000080;">???</span><span style="color:#ff0000;"> ",</span><span style="color:#000080;">"%Y '%M' '%d'")</span><span style="color:#0000ff;">), INTERVAL (7-1) DAY) AND STR_TO_DATE</span><span style="color:rgb(0,0,128);"> </span><span style="color:rgb(255,0,0);">" </span><span style="color:rgb(0,0,128);">???</span><span style="color:rgb(255,0,0);"> ",</span><span style="color:rgb(0,0,128);">"%Y '%M' '%d'")</span>"</div>
<div style="font-family:arial, sans-serif;font-size:small;"> </div>
<div style="font-family:arial, sans-serif;font-size:small;"><span style="color:#b22222;">? -> Year [Integer] ->2015</span></div>
<div style="font-family:arial, sans-serif;font-size:small;"><span style="color:#b22222;">? - >Month[String] -> 'March'</span></div>
<div style="font-family:arial, sans-serif;font-size:small;"><span style="color:#b22222;">? -> Day [String] -> '03'</span></div>
<div style="font-family:arial, sans-serif;font-size:small;"> </div>
<div style="font-family:arial, sans-serif;font-size:small;"><span style="color:#000000;">When i place</span><span style="color:#b22222;"> ???</span><span style="color:#000000;"> inside</span><span style="color:#b22222;"> ""</span> i am getting error. I know if i place it like that then it will be considered ??? as string and value of parameter wont be passed. But i tried other ways also.. nothing is working out.Please help me how i can rewrite this code.</div>
<div style="font-family:arial, sans-serif;font-size:small;"> </div>
<div style="font-family:arial, sans-serif;font-size:small;"> </div>
<div style="font-family:arial, sans-serif;font-size:small;">Thanks in advance.</div>
