Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Parameter within Stored Procedure
Migrateduser
<p>Hi guys,</p><p> </p><p>I need your help with a date Parameter in a Stored Procedure</p><p> </p><p>Following SQL Works within MSSQL and Firebird:</p><p> </p><p>SELECT *<br />
FROM specificProcedure ([color=#0000cd;]'String as where clause'[/color]) p</p><pre class="_prettyXprint _lang-sql">SELECT *FROM specificProcedure (' where TYPE = 0 and DDATE between ''2014-05-01 00:00'' and ''2014-05-31 23:59'' ) ') p</pre><p>Instead of ' '2014-05-01' ' I would like to use ? as Parameter. But I always get a failure.</p><p>I think it is because the use of ' '. So the Report don´t parse ? as Date but as figure.</p><p> </p><p>If I look into the log file it parse like .... and DDATE between ? and ? and not DDATE between '2014-05-01'</p><p>So I guess, I have to call the parameter in another way.</p><p> </p><p>Please give me your advice.</p><p> </p><p>best regards</p><p>rf</p><p> </p>
Find more posts tagged with
Comments
There are no comments yet