>>> 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) " >>>>>
>>select word,ur from dict where UPPER(word) = Upper(Trim(thisform.container6.texte.Value)) ; >> order by word into cursor crsGrid nofilter>>
lcValue = Upper(Trim(thisform.container6.texte.Value)) select word,ur from dict where UPPER(word) = m.lcValue ; order by word into cursor crsGrid nofilterThere is nothing much you can do in addition to speed up this simple query.