>>>>>>select * from myTable where nNumber IN (Fld1, Fld2, Fld3). >>>>>>>>>>>>
>CREATE CURSOR crsTest (Fld1 I, Fld2 I) >FOR lnFor = 1 TO 20 > INSERT INTO crsTest VALUES(lnFor,20-lnfor) >NEXT >INDEX ON Fld1 TAG Fld1 >INDEX ON Fld2 TAG Fld2 >lnNumber = 12 > >SYS(3054,12,[tst]) >SELECT * FROM crsTest WHERE m.lnNumber IN(Fld1, Fld2) >MESSAGEBOX(tst) > >SELECT * FROM crsTest WHERE Fld1 = m.lnNumber OR Fld2 = m.lnNumber > >MESSAGEBOX(tst) >SYS(3054,0) >VFP is too simple!
CREATE CURSOR crsTest (Fld1 I, Fld2 I) FOR lnFor = 1 TO 20 INSERT INTO crsTest VALUES(lnFor,20-lnfor) NEXT INDEX ON Fld1 TAG Fld1 INDEX ON Fld2 TAG Fld2 lnNumber = 12 SYS(3054,12,[tst]) SELECT * FROM crsTest WHERE m.lnNumber IN(Fld1, Fld2) MESSAGEBOX(tst) SELECT * FROM crsTest WHERE Fld1 = m.lnNumber OR Fld2 = m.lnNumber MESSAGEBOX(tst) * not optimized !!!! SELECT * FROM crsTest WHERE m.lnNumber = Fld1 OR m.lnNumber = Fld2 MESSAGEBOX(tst) SYS(3054,0)