Subject rowset.count()
From Vic <vicpiter@mail.ru>
Date Fri, 06 Sep 2019 10:33:14 -0400
Newsgroups dbase.getting-started

Hi, everybody !

I do filter rowset (depending on user's wish) through rowset.canGetRow
function. rowset is well updated in grid. Still rowset.count() return the same
number of rows. doesn't it respect filtering or my code is wrong ? :

do case
    case form.checkbox2.value=true.and.form.checkbox3.value=true
           form.query1.rowset.canGetRow =  {||this.fields["def_id"].value>1.and.this.fields["control_id"].value=true}
   case form.checkbox2.value=false.and.form.checkbox3.value=true
          form.query1.rowset.canGetRow = {||this.fields["control_id"].value=true}
  case form.checkbox2.value=true.and.form.checkbox3.value=false
         form.query1.rowset.canGetRow = {||this.fields["def_id"].value>1}          
otherwise
         form.query1.rowset.canGetRow ={||this.fields["key_id"].value>1}
endcase        
form.query1.rowset.first()
form.Entryfield2.value=form.query1.rowset.count()

Thanks
Best Regards
Viktor