Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed Needed
Message
From
24/05/2011 02:15:29
 
 
To
23/05/2011 20:41:26
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01511481
Message ID:
01511538
Views:
57
>so how should I write codes according to your given line
>
>padr(value, LensetBeforeLoopAccordingToFieldLen)
Select Master
if tagno("codes")=0
   index on codes tag codes
endif
if tagno("pqty")=0
   index on pqty tag pqty
endif
Replace All pqty With qty  && index could hurt here - measure effect of 2. index!
lnLenMaster = len(codes)
....
** for loop to scroll on sales.dbf
select sales
for  && scan if possible
        cur_code = padr(codes, m.lnLenMaster)
        Select purchase
	Do While endloop>0  && move to scan if possible
		Select Master
		Locate For codes=m.cur_code And pqty>0
		If Found()
....
endfor && scan 
Previous
Reply
Map
View

Click here to load this message in the networking platform