I am facing one issue while using date column in where clasue in QBVA.
I have used following query in
SELECT DISTINCT MPL_POL_CARR_LOC FROM DM_DBO.MDOCS_POLICY_LKUP WHERE mpl_company_nbr = '$value(mdocs_company_nbr)' AND mpl_policy_eff_date = '$value(mdocs_policy_eff_dt)' order by MPL_POL_CARR_LOC asc
In above query both mpl_policy_eff_date and mdocs_policy_eff_dt are date type.
I could install dar successfuly. But when accessing this attribute I am getting following error.
Wed Jun 30 06:48:12 2010 106193 [DM_QUERY_E_CURSOR_ERROR]error: "A database error has occurred during the creation of a cursor ('ORA-01858: a non-numeric character was found where a numeric was expected
Please let me know if anybody has used DATE field in QBVA.
I see that your thread has been unanswered yet. For Quicker reply please post this question in the following group:
Here are few links/threads which may be useful:
thanks for the interest in my post.
I am able to use QBVA successfuly for string data type.
But it gives error for when i use date data type.
I think its limitation of QBVA.
Thanks for replay Rajalakshmi .
I tried taking out date function also. But it did not work.
Have you ever used QBVA for date columns successfuly?
Did following example worked for you?