Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow
Message
From
07/07/2008 05:56:45
 
 
To
07/07/2008 05:41:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Slow
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01329335
Message ID:
01329338
Views:
16
>f1=national number
>f4=my file number as 00123/234
USE x2
*** Index should already exist!
*** INDEX on f4 TO kk

*** assuming an index on f1 exists!
If Seek(ALLTRIM(thisform.text1.value), "X2", "f1")
  local lcFind
  Store F4 to lcFind, thisform.text2.value
  SELECT f1,f2,f3,f5,f6 FROM x2 WHERE f4=m.lcFind ;
     order BY f5;
     into CURSOR mycur

  S = _tally && or Reccount()
  thisform.grid1.RecordSource="mycur"
ELSE
  MESSAGEBOX("not found")
ENDIF
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform