Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help selecting dates after a certain date

error.jpg

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

31 Replies
Not applicable
Author

update your topic and add file

Not applicable
Author

I've shared the application.. Any ideas yet ?

MayilVahanan

Hi

There is no DDate in your application.  Can u include that and reload it?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

As Mayil says. You need to include Ddate from somewhere!

Not applicable
Author

Re-uploaded with that in.

MayilVahanan

Hi darrenrsa..

Stil i can't still DDate

Can you reload this and attach it?

Load CustomerCode,

ItemCode,

Qty,

Date(DDate,'DD/MM/YYYY')as DDate,

SalesmanCode;

SQL Select

CustomerCode,

ItemCode,

DDate,

Qty,

SalesmanCode

From HistoryLines;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Sorry for the delete, You should reload it like mayil says. I posted wrong!

If that does not work are you then able to reload DDate without  a function around it?

Load CustomerCode,

ItemCode,

Qty,

DDate,

SalesmanCode;

SQL Select

CustomerCode,

ItemCode,

DDate,

Qty,

SalesmanCode

From HistoryLines;

I cannot see why this should not work - DDate is in Historylines right? and is written DDate not Ddate?

Not applicable
Author

ErrorSource: Pervasive.SQL V9 OLE DB Provider, ErrorMsg: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

SQL Select

CustomerCode,

ItemCode,

DDate,

Qty,

SalesmanCode

From HistoryLines

The moment I load it with mayil or your way.   DDate is in HistoryLines written as "DDate" I'm busy looking at it. The moment I take DDate out of load/select, everything loads perfectly including HistoryLines,  the moment I add DDate, it fails with the above error. 

I've reattached "test" the way that you asked for, Mayil.

I appreciate your help so very much

Not applicable
Author

have you tried to delete the connectionstring and add it again?

However it seems very strange.

Not applicable
Author

Plenty times, even creating new QVW documents that just load that file, fails the moment I add DDate