>>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.
>
>Are you sure that you have sent a TableUpdate() to save your existing data before running the view? Views (and other SQL code) are run from data on the network, so changes still in your buffers are not found.
>
>Also, you might check the Novell write cache behavior. The updated information may still be in the network cache, not written to disk.
>
>>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.
>
>No, it's 2 GB (2,000 MB). Gives you a lot more space to work. :-)
>
>>Tai SC
>
>HTH
>Barbara
I don't think it has anything to do with data not in disk. The data is all in the table. I am not querying any newly entered data. I am just doing query with different parameters on old information. With the same parameters, the query returned different results from what I saw just two minutes before. The result is erratic. Nobody except me is running it. If I don't see the results, I won't believe it.
Any other possibility?
Tai SC
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement