Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select Statement appears to be filtering
Message
De
30/06/2006 08:50:35
Mike Yearwood
Toronto, Ontario, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01132775
Message ID:
01133041
Vues:
21
>All,
>
>I am querying a VFP table that has about 1.5 million records. The table is indexed on a date field called aaddb. My query shows that it returned 13,533 records on the status bar. Then the status bar message changes and it states: Tcursor(c:\arrestees.dbf) Record: 24/1427204.
>Only the records I have selected show in the browse window. However if I do a ?reccount() it shows that there are 1427204 records in my cursor. If I select all of the records from the cursor into a new cursor I get all 1427204 records from the original table.
>
>This is my query.
>
>SELECT * FROM arrestees where BETWEEN(aaddb, CTOD('12/30/1939'), CTOD('12/29/1941')) into cursor tCursor
>
>
>How can I get just the records I am trying to select? This is a new one on me.

That's a long-known issue. If the query is 100% rushmore optimizable, vfp may just do a SET FILTER. I have been adding NOFILTER to every query for many years now.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform