I have a parameterized view which behaves inconsistently under network environment. My parameterized view is created with 3 parameters, begin_date, end_date and stock_code. Everyone of them has got data in it. The file size is about 1.5 Mbytes.

While querying in standalone PC, it works perfectly fine. However when it is brought to network environment (Novell Netware 4.1, my program is loaded on network drive), it gives inconsistent result. Sometimes, the result shows blank. Sometimes, the result shows the previous query.

Any idea what is wrong? Thx in advance.

I also read somewhere that the limit of the table size / files size is 2 Mbytes. Is it true? What can I do if my file size exceeds 2 Mbytes.


Tai SC