Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How this query will fast
Message
From
11/06/2010 11:12:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How this query will fast
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01468545
Message ID:
01468545
Views:
106
How this query will work fast. It has 37000 records, and takes .28 time to load.
 thisform.container6.searche.RecordSourceType=4  &&grid
 
     thisform.container6.searche.RecordSource = "select word,ur from dict "+;
                " where UPPER(word) = Upper(Trim(thisform.container6.texte.Value))"+;
                " order by word into cursor SYS(2015)  "
Next
Reply
Map
View

Click here to load this message in the networking platform