
                        ComboBox c ᪮.

  ᮧ   ᪠ Internet Explorer.  
ᠩ Explorer 뤠 ᯨ᮪ ᮢ騩     ᮬ. 
뫠   訫   ਬ  ᢮ ஥  롮 祭 
ࠢ筨.
  ᬮॢ  㬥  Combobox  ᮧ  .

  ᯮ짮 室 । ᫥騥 ᢮⢠:

IncrementalSearch - ।  ᪠ (.T. -  ࠧ襭, .F. -
                   饭)
RowSource - । 筨 . 筨  ᥣ  SQl
              롨ࠥ 祭  롮   Combo.
cNmTexAlias - ।    ஥ 롨  
             SQL-Select', ⮡  ⨨ Destroy ꥪ 
                 (.. 㡨ࠥ   ᮡ)
SrchRowSource -  ᢮⢮ ࠢ ᪮,    ।
                ᪠  ࠦ   㪢  
               ᮢ ᨬ.  ஥  ᯮ짮 LIKE
               SELECT-SQL ⮬   ࠢ  LIKE.

ਬ 祭 ᢮:
1.    ᨬ

RowSource="SELECT name, id, UPPER(name) FROM S_pred ORDER BY 3 INTO CURSOR
                  TexSrch"
SrchRowSource="THIS.cOldRowSource+' WHERE UPPER(name) LIKE ['+;
             UPPER(THIS.cLocateExpression)+'%] UNION SELECT ['+;
             THIS.DisplayValue+'], ['+THIS.Value+'], CHR(0) FROM TexCboSearch '"
cNmTexAlias="TexSrch"

2.  ᮢ ᨬ

RowSource="SELECT name, id, UPPER(name) FROM S_pred ORDER BY 3 INTO CURSOR
                  TexSrch"
SrchRowSource="THIS.cOldRowSource+' WHERE UPPER(name) LIKE [%'+;
             UPPER(THIS.cLocateExpression)+'%] UNION SELECT ['+;
             THIS.DisplayValue+'], ['+THIS.Value+'], CHR(0) FROM TexCboSearch '"
cNmTexAlias="TexSrch"

3. 롮 祭  ᭮ ⠡  । ᫮.

RowSource="SELECT name, id, UPPER(name) FROM S_pred ORDER BY 3 INTO CURSOR
                  TexSrch WHERE Group="1""
SrchRowSource="THIS.cOldRowSource+' AND UPPER(name) LIKE [%'+;
             UPPER(THIS.cLocateExpression)+'%] UNION SELECT ['+;
             THIS.DisplayValue+'], ['+THIS.Value+'], CHR(0) FROM TexCboSearch '"
cNmTexAlias="TexSrch"
**     WHERE ᯮ   SELECT-SQL, 
᢮⢥ WHERE   AND.  ⥫, .. ᯮ 
 ய⠭.

P.S.    砭, ᫨ 室  ᭮ ⠡ 롨 
   ᢮⢮ cSrchRowSource 室 㪠 CHR(0)  㣮
ࠦ ⮡ ࠢ쭮 ࠡ⠫ UNION.
  ᫥ 易⥫쭮 । ORDER BY  ⤥쭮 ப 
 ᪮ ࠦ  㤥 ᯮ  孥 ப.

 砭,    뫠  E-mail.

 訬 ﬨ.

 .
E-mail: oleynik99@mail.ru

-ணࠬ ଠ  "-⥬" .ᥭ㪨
URL: WWW.BASS.KMV.RU

