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
update your topic and add file
I've shared the application.. Any ideas yet ?
Hi
There is no DDate in your application. Can u include that and reload it?
As Mayil says. You need to include Ddate from somewhere!
Re-uploaded with that in.
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;
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?
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
have you tried to delete the connectionstring and add it again?
However it seems very strange.
Plenty times, even creating new QVW documents that just load that file, fails the moment I add DDate