Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have four tables... see tables below
ITEM
Item code, Item Desc
RECEIVING
Received date, Item code
DELIVERY
Delivery date, Item code
CALENDAR
Received date, Delivery Date
When I load these tables, it will have loop issue... Please help me get over this... I really wanted to have this calendar so that, when I will be getting data of 9-4-2009, it will show the data wherein Delivery date = 9-4-2009 and Received date = 9-4-2009
And to add, i also have comparison report like Delivery vs. Received.
So please, help me. Thanks.
Best Regards,
Bill
Hi,
You can join manually your table like this :
ITEM:
load item code, item desc from item.qvd(qvd) ;
join load
item code, received date from receiving.qvd(qvd);
join load
item code, delivery date from delivery.qvd(qvd);
So you have only 1 table with all of your information in it.
Regards,
Vincent
Hi Vincent,
I forgot to tell you this
ITEM
Item code, Item Desc
RECEIVING
Item code, Received No
DELIVERY
Item code, Delivery No.
CALENDAR
Received date, Delivery Date
RECEIVE HEADER
Received No, Received date
DELIVERY HEADER
Delivery No., Delivery date
These are complete tables...
Join all tables together.
RECEIVING and DELIVERY will join on Item Code.
The 2 headers will join on Received No and Delivery No.
Vincent
Will do your suggestion Vin, I hope it will work.
I have another concern, why is that 48MB of qvw load a bit slow. What should I do? How do I make it fast loading?
It's hard to give you an answer concerning the speed, a lot of factors can interact (your computer memory, the size of the data, the way the tables are joined, the complexity of expression in your objects).
And what is slow exactly ? Opening your application ? Reloading data ? Refreshing sheets ?
In reloading data, I understand why it slows down. But how about in saving? Saving the application, like click the save button, it takes seconds. Is it really like that when your file is MB?
On my side, i'm working today on an application with a 230MB QVW, QV takes 1GB of memory, there are 17 sheets, more than 200 objects and more than 8 millions of rows in the tables. And, it takes 60 seconds to save the file, ouch.
I tried to delete all sheets and it took the same time, so it's only due to the quantity of data.