Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can this code be faster?
Message
From
19/08/2003 15:00:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Can this code be faster?
Miscellaneous
Thread ID:
00821524
Message ID:
00821524
Views:
53
We are searching records for any condition using a from and to condition. Records are stored like so:

SMITH*JAMES
SMITH III*MICHAEL
SMITH JR*JOHN
SMITHERMAN*PETER

I must account for the user entering from: SA to: SMITH or from: SMITH to: SMITH, or from: A to: Z, etc. SMITH to SMITH should NOT include SMITHERMAN...

The below code works (If exact is on and near is off), but can it be faster?
xreturn=.T.  && include this record, .f. if record does not meet condition
  IF !EMPTY(xfrom) OR !EMPTY(xto)
    IF ALLTRIM(UPPER(xfrom))=ALLTRIM(UPPER(xto))
      IF ALLTRIM(UPPER(xfrom)) $ LEFT(UPPER(LEFT(STRTRAN(insured.po_name," ","*",1),;
          AT("*",STRTRAN(insured.po_name," ","*",1))-1)),LEN(ALLTRIM(UPPER(xfrom)))) ;
          .AND. UPPER(LEFT(STRTRAN(insured.po_name," ","*",1),;
          AT("*",STRTRAN(insured.po_name," ","*",1))-1));
          <= UPPER(ALLTRIM(xto))
        ? po_name+ "    YES a match"
        xreturn = .T.
      ELSE	&& not a match
        ? po_name+"    NO not a match"
        xreturn = .F.
      ENDIF
    ELSE
      *--TCH 08/13/2003 * for  SMITH III*JAMES, etc
      *IF !BETWEEN(UPPER(LEFT(insured.po_name,AT("*",insured.po_name)-1)),xfrom,xto)
      IF !BETWEEN(UPPER(LEFT(STRTRAN(insured.po_name," ","*",1),;
          AT("*",STRTRAN(insured.po_name," ","*",1))-1)),xfrom,xto)
        xreturn = .F.
      ENDIF
    ENDIF
  ENDIF
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Next
Reply
Map
View

Click here to load this message in the networking platform