SELECT cymma_chet, bid_cheta, dt_otk_ch ;  
  FROM vklad_banka 
    where  dt_otk_ch>{01.01.2011}  ;
         and dt_otk_ch<{31.03.2011};
       INTO table DepositRange
     index ON bid_cheta+cymma_chet
    BROWSE 

SELECT cymma_chet, bid_cheta, dt_otk_ch ;  
  FROM vklad_banka ;
    where  dt_otk_ch BETWEEN {^2011.01.01} and {^2011.31.03} ;
       INTO CURSOR DepositRange NOFILTER

BROWSE

[SRC C++]SELECT cymma_chet, bid_cheta, dt_otk_ch ;  
FROM vklad_banka 
    [SRC sql]where  dt_otk_ch>={01.01.2011}  ;
         and dt_otk_ch=<{31.03.2011};

SELECT cymma_chet,dt_otk_ch,infor.fio,vud_vklad.naz_vklad;    
    FROM vklad_banka  ;  
    LEFT OUTER JOIN infor;
    LEFT OUTER JOIN vud_vklad;
    ON vklad_banka.kod_kl = infor.kod;
    ON vklad_banka.bid_cheta = vud_vklad.kod;
    where  
    INTO table DepositRange
 BROWSE 

Command contains unrecognized phrase/keyword

Command contains unrecognized phrase/keyword

 ch=thisform.text1.value
 
SELECT cymma_chet,dt_otk_ch,infor.fio,vud_vklad.naz_vklad;    
    FROM vklad_banka ;  
     LEFT OUTER JOIN infor ON vklad_banka.kod_kl = infor.kod;
    LEFT OUTER JOIN vud_vklad ON vklad_banka.bid_cheta = vud_vklad.kod;
    where  Where STR(nomer_chet) = ch;
   * LIKE(ch,STR(nomer_chet));*
    INTO table DepositRange;
 BROWSE 
 
 

ch=thisform.text1.value
 
SELECT ;
    vklad_banka.cymma_chet,;
    vklad_banka.dt_otk_ch,;
    infor.fio,;
    vud_vklad.naz_vklad ;    
FROM vklad_banka ;  
LEFT OUTER JOIN infor ON vklad_banka.kod_kl = infor.kod ;
LEFT OUTER JOIN vud_vklad ON vklad_banka.bid_cheta = vud_vklad.kod ;
Where STR(vklad_banka.nomer_chet) = ch ;
INTO     CURSOR     DepositRange NOFILTER

BROWSE

Where STR(vklad_banka.nomer_chet) = ch ;[SRC sql]
Ставлю 

ch=thisform.text1.value
 
SELECT ;
    vklad_banka.cymma_chet,;
    vklad_banka.dt_otk_ch,;
    infor.fio,;
    vud_vklad.naz_vklad ;    
FROM vklad_banka ;  
LEFT OUTER JOIN infor ON vklad_banka.kod_kl = infor.kod ;
LEFT OUTER JOIN vud_vklad ON vklad_banka.bid_cheta = vud_vklad.kod ;
Where ch $ vklad_banka.nomer_chet;
INTO CURSOR     DepositRange NOFILTER

BROWSE

?'2' $ str(123)

SELECT ;
    vklad_banka.cymma_chet,;
    vklad_banka.dt_otk_ch,;
    vklad_banka.nomer_chet,;
    infor.fio,;
    vud_vklad.naz_vklad ;    
FROM vklad_banka ;  
LEFT OUTER JOIN infor ON vklad_banka.kod_kl = infor.kod ;
LEFT OUTER JOIN vud_vklad ON vklad_banka.bid_cheta = vud_vklad.kod ;
Where index ON kod_kl TO kod
      scan WHILE (!EOF())
      p = vklad_banka.kod_kl
      k=0
      DO WHILE  p = vklad_banka.kod_kl 
      k=k+1
      skip 
      ENDDO 
      IIF (k>=2,;
INTO CURSOR DepositRange NOFILTER, )
ENDSCAN 
BROWSE

SELECT infor.fio, COUNT() as nKol ;    
FROM  infor ;  
LEFT OUTER JOIN vklad_banka ON infor.kod = vklad_banka.kod_kl  ;
ORDER BY 1;
GROUP BY 1;
HAVING BY nKol > 1;
INTO CURSOR curList

HAVING BY nKol > 1;

SELECT Infor.fio, Infor.dom_tel, Vud_vklad.naz_vklad,;
  Vklad_banka.nomer_chet, Vklad_banka.cymma_chet, Vklad_banka.dt_otk_ch,;
  COUNT(DISTINCT Infor.fio) AS êîëè÷åñòâî;
 FROM ;
     praktikabd!infor ;
    INNER JOIN praktikabd!vklad_banka ;
   ON  Infor.kod = Vklad_banka.kod_kl ;
    INNER JOIN praktikabd!vud_vklad ;
   ON  Vud_vklad.kod = Vklad_banka.bid_cheta;
 WHERE  Vklad_banka.bid_cheta >= ( 2 );
 GROUP BY Infor.fio, Infor.dom_tel, Vud_vklad.naz_vklad,;
  Vklad_banka.nomer_chet, Vklad_banka.cymma_chet, Vklad_banka.dt_otk_ch;
 ORDER BY 7