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