Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following in my script:
select top 2000
CASE
cb.FinancialPeriod,
c
cb.Actual
from plc
where financialperiod between ($(v_userStart)) and ($(v_userEnd));
I have then setup the two variables in in the document properties with some dates set in both. However, when I reload the app no data appears. Can you please help? What am I missing?
Hi
Not sure whar DBMS you are using, but it probably needs quotes on the dates, like this:
financialperiod between '$(v_userStart)' and '$(v_userEnd))'
HTH
Jonathan
If that is not it, perhaps the variables are nor returning what you expect. If you switch to debug mode and put breakpoint before the Select, them you can step to that point and see exactly what query is being sent to the DBMS.
its a SQL db
Hi,
Check the variables whether they are getting values in it, may be that is the issue. Also date values need to be surrounded by single quotes.
select top 2000
CASE
cb.FinancialPeriod,
c
cb.Actual
from plc
where financialperiod between '$(v_userStart)' and '$(v_userEnd);
Also check the date formats are same in both variables and your date field.
Regards,
Jagan.
it looks like i had missing quotes. Thanks all
Hi,
Please close this thread by giving correct and helpful answer to the helpful posts.
Regards,
Jagan.