Loop Problem issue...

[#1]

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

[vincent_ardiet]

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

[#3]

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...

[vincent_ardiet]

Join all tables together.

RECEIVING and DELIVERY will join on Item Code.

The 2 headers will join on Received No and Delivery No.

Vincent

[#5]

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?

[vincent_ardiet]

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 ?

[#7]

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?

[vincent_ardiet]

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.