Hi,
Can anyone explain me some strange behaviour using Visual Foxpro 7?
The problem is that i have an application that has several relations
on a material file and that the file is about 20 mb.
Sometimes when i use the folowing line in code the application
is consuming all 20 mb from the fileserver to the workstation:
i_ordernr = 1002
select ordregl
locate for year(orders.dOrddate)=year(date()) and orders.iordernr = i_ordernr
if found()
-----
endif
When i do the following code the network traffic is 50 kilobytes!!! :
i_ordernr = 1002
select ordregl
select iordernr from orders into cursor dummy where year(orders.dOrddate)= year(date()) and orders.iordernr = i_ordernr
if _tally > 0
-----
endif
How can this be?
dOrddate,iordernr are indexed into a .cdx file
Suggestions?
best regards,
Piet
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