Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How this query will fast
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01468545
Message ID:
01468545
Vues:
110
How this query will work fast. It has 37000 records, and takes .28 time to load.
thisform.container6.searche.RecordSourceType=4&&gridthisform.container6.searche.RecordSource = "select word,ur from dict "+;
" where UPPER(word) = Upper(Trim(thisform.container6.texte.Value))"+;
" order by word into cursor SYS(2015) "
