Groups > dBase > dBase bug reports > Re: Filter in runtime !




Filter in runtime !

Filter in runtime !
Sun, 9 Mar 2008 20:06:04 +0100 


Hello,

this is working on dbase but not on runtime
 form.rowset.filter=[choice=true]
does show the whole table activ and non activ , altough should showing the
non activ mentioned adresses
form.rowset.filter=[choice<>true]
does only show the as active mentioned adresses

 is this a bug ?

on the same form i have 20 different categories, filtering by categorie no 
problem


function activBOX_onChange

       form.rowset.indexname ="countrycode"
      do case
       case this.value ="Non active"
        form.rowset.clearfilter()
        form.rowset.filter=[choice=true]
        form.rowset.first()
       case this.value = "Active"
        form.rowset.clearfilter()
        form.rowset.filter=[choice<>true]
        form.rowset.first()
       otherwise
        form.rowset.clearfilter()
      endcase
    return
Post Reply
Re: Filter in runtime !
Mon, 10 Mar 2008 00:47:28 -040 
In article <1OF1gthgIHA.1232@news-server>, dfcc@skynet.be says...
> 
> Hello,
> 
> this is working on dbase but not on runtime
>  form.rowset.filter=[choice=true]
> does show the whole table activ and non activ , altough should showing the
> non activ mentioned adresses
> form.rowset.filter=[choice<>true]
> does only show the as active mentioned adresses
> 
>  is this a bug ?
> 
> on the same form i have 20 different categories, filtering by categorie no

> problem
 


Dirk,

To help dBI, can you tell them the version of dBASE and the version of 
Windows you are using? 

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
Post Reply
Re: Filter in runtime !
Mon, 10 Mar 2008 07:39:37 +010 
Hello again,


please
 Version 2.6.1.3

Dirk


"Dirk Cardoen" <dfcc@skynet.be> schreef in bericht 
news:1OF1gthgIHA.1232@news-server...
>
>
>
> Hello,
>
> this is working on dbase but not on runtime
> form.rowset.filter=[choice=true]
> does show the whole table activ and non activ , altough should showing the
> non activ mentioned adresses
> form.rowset.filter=[choice<>true]
> does only show the as active mentioned adresses
>
> is this a bug ?
>
> on the same form i have 20 different categories, filtering by categorie no

> problem
>
>
> function activBOX_onChange
>
>       form.rowset.indexname ="countrycode"
>      do case
>       case this.value ="Non active"
>        form.rowset.clearfilter()
>        form.rowset.filter=[choice=true]
>        form.rowset.first()
>       case this.value = "Active"
>        form.rowset.clearfilter()
>        form.rowset.filter=[choice<>true]
>        form.rowset.first()
>       otherwise
>        form.rowset.clearfilter()
>      endcase
>    return
>
>
Post Reply
Re: Filter in runtime !
Thu, 13 Mar 2008 11:23:27 -040 
Hi Dirk, 
Even with your function code below, I am unable to re-create the issue.
Is there any way you can provide a turnkey?

Thanks, Kathy
QA
dBI


In article <1OF1gthgIHA.1232@news-server>, dfcc@skynet.be says...
> 
> 
> 
> Hello,
> 
> this is working on dbase but not on runtime
>  form.rowset.filter=[choice=true]
> does show the whole table activ and non activ , altough should showing the
> non activ mentioned adresses
> form.rowset.filter=[choice<>true]
> does only show the as active mentioned adresses
> 
>  is this a bug ?
> 
> on the same form i have 20 different categories, filtering by categorie no

> problem
> 
> 
> function activBOX_onChange
> 
>        form.rowset.indexname ="countrycode"
>       do case
>        case this.value ="Non active"
>         form.rowset.clearfilter()
>         form.rowset.filter=[choice=true]
>         form.rowset.first()
>        case this.value = "Active"
>         form.rowset.clearfilter()
>         form.rowset.filter=[choice<>true]
>         form.rowset.first()
>        otherwise
>         form.rowset.clearfilter()
>       endcase
>     return
> 
> 
> 

-- 
Thanks, Kathy
Post Reply
Re: Filter in runtime !
Mon, 24 Mar 2008 17:11:32 +010 
Goodday,
out of office for a couple of weeks,
Find out the problem
dataSource = 'array {"Select()","all
companies","Active","Non Active"}'
dataSource = 'array {"Select()","all
companies","active","non active"}'
 into the datasource no capitals should be used
 i have changed the capitals and now sorting active as non active
sorry for any inconvience
thanks any
Dirk C
Belgium,
function activBOX_onChange
     form.rowset.indexname ="countrycode"
      do case
       case this.value ="active"
      //  form.rowset.clearfilter()
        form.rowset.filter=[choice<>true]
        form.rowset.first()
       case this.value ="non active"
      //  form.rowset.clearfilter()
        form.rowset.filter=[choice=true]
        form.rowset.first()
       otherwise
        form.rowset.clearfilter()
        form.rowset.first()
      endcase
    return
"Dirk Cardoen" <dfcc@skynet.be> schreef in bericht 
news:1OF1gthgIHA.1232@news-server...
>
>
>
> Hello,
>
> this is working on dbase but not on runtime
> form.rowset.filter=[choice=true]
> does show the whole table activ and non activ , altough should showing the
> non activ mentioned adresses
> form.rowset.filter=[choice<>true]
> does only show the as active mentioned adresses
>
> is this a bug ?
>
> on the same form i have 20 different categories, filtering by categorie no
> problem
>
>
> function activBOX_onChange
>
>       form.rowset.indexname ="countrycode"
>      do case
>       case this.value ="Non active"
>        form.rowset.clearfilter()
>        form.rowset.filter=[choice=true]
>        form.rowset.first()
>       case this.value = "Active"
>        form.rowset.clearfilter()
>        form.rowset.filter=[choice<>true]
>        form.rowset.first()
>       otherwise
>        form.rowset.clearfilter()
>      endcase
>    return
>
>
Post Reply
about | contact