Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recall and Select Sql
Message
From
19/07/2003 05:54:02
 
 
To
18/07/2003 13:17:43
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00811558
Message ID:
00811753
Views:
9
Hi Pedro,

SELECT NumDoc FROM LinhaFac WHERE recallAble INTO CURSOR docToRecal

fast way on VFP depend by data,index context.

Two way exist:

* if RECCOUNT(docToRecal)/RECCOUNT(LinhaFac)<<1
INDEX ON NumDoc TAG TAG1	&& ACTIVE
SELECT docToRecal
SCAN
  RECALL NEXT 1 WHILE SEEK(docToRecal.NumDoc) IN LinhaFac 
ENDSCAN
* if RECCOUNT(docToRecal)/RECCOUNT(LinhaFac)<1
SELECT docToRecal
INDEX ON NumDoc TAG TAG2
RECALL FOR DELETED() AND KEYMATCH(NumDoc,1,'docToRecal') IN LinhaFac 
Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform