Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sorry if this is simple... I'm reading my data from a pervasive sql database, everything works perfectly, but when I
add load "DDate" it always crashed with OLE DB multiple step operation error, I'm assuming it's because the DDate has too many
transactions (it's years worth of invoices). How can I make DDate only load transactions after a certain date, E.g. 01/01/2013 ?
Thank you in advance
I'm snooping in the Table, and see that "DDate" is of type "Date" and in .net framework it says you need "
getdatetime()" function to get the date in format (dd-mm-yyyy hh.mm.ss). does this help?
http://www.pervasive.com/Portals/55/documents/PSQLv9/readme_v970.htm
I found the problem, it does not lay with Qlikview. The problem was PSQL V9. The above hotfix for PSQL
address the following issue
58407 | Invalid date/time/timestamp error from UDF called in a stored procedure |
So this is sorted out. Thank you so much to all of you, I have no doubt your answers were perfect.