Hi Soykan,

Specify the keyword NOFILTER. Example:

SELECT * from plan ;
into CURSOR crsresult NOFILTER

>Hi All,
>
>there is shown below different SQL syntax the True one is first.:)
>the other ones when i put additional items such as comboboxes,textboxes and without any selected items from its the Syntax getting different reccounts ...the details is like under .
>What is the problem , which is wrong and what is your recommends... TIA
>
>Data entry form property :
>Private Data Session,Pessimistic,DEnv tables BufferMode =5
>
>Query items :
>cmbatolye,cmbislem,cmbmusteri,cmbkumascinsi &&on the DBF type C
>type 3 SQL , Rowsource select .......
>
>ctarihi,gtarihi,starihi,termint textboxlar && on the DBF type D
>value {},date()
>
>chaftano,ghaftano,shaftano textboxlar && on the DBF type C
>value None
>
>shaftagun,chaftagun,gfahtagun combolar &&on the DBF Type C
>value (Monday,......)
>
>
>
>SELECT * from plan ;
>into CURSOR crsresult && RECCOUNT 24
>
>*---------------------------------------------
>
>SELECT * from plan ;
>WHERE ;
>atolye=thisform.cmbatolye.Value AND ; &¬ selected
>islem=thisform.cmbislem.Value AND ; &¬ selected
>musteri=thisform.cmbmusteri.Value and; &¬ selected
>orderno=thisform.cmborderno.Value and; &¬ selected
>kumascinsi=thisform.cmbkumascinsi.Value AND ; &¬ selected
>termint between thisform.tar1.Value AND thisform.tar2.Value ; && ={} and =date()
>into CURSOR crsresult && RECCOUNT 11
>
>*--------------------------------------------------
>
>SELECT * from plan ;
>WHERE ;
>atolye=thisform.cmbatolye.Value AND ; &¬ selected
>islem=thisform.cmbislem.Value AND ; &¬ selected
>musteri=thisform.cmbmusteri.Value and; &¬ selected
>orderno=thisform.cmborderno.Value and; &¬ selected
>kumascinsi=thisform.cmbkumascinsi.Value AND ; &¬ selected
>termint between thisform.tar1.Value AND thisform.tar2.Value AND ; &¬ selected
>dosyano=thisform.txtdosyano.Value AND ; && ""
>ctarihi between thisform.tar3.Value AND thisform.tar4.Value AND ; && ={}, =date()
>gtarihi between thisform.tar5.Value AND thisform.tar6.Value AND ; && ={}, =date()
>starihi between thisform.tar7.Value AND thisform.tar8.Value AND ; && ={}, =date()
>chaftano between thisform.txtchaftano.Value AND thisform.txtchaftano1.value AND ; && ""-""
>ghaftano between thisform.txtghaftano.Value AND thisform.txtghaftano1.value AND ; && "" - ""
>shaftano between thisform.txtshaftano.Value AND thisform.txtshaftano1.Value AND ; && ""-""
>shaftagun= thisform.cmbshaftagun.Value AND; &¬ selected
>chaftagun= thisform.cmbchaftagun.Value AND; &¬ selected
>ghaftagun= thisform.cmbghaftagun.Value ; &¬ selected
>into CURSOR crsresult && RECCOUNT 11