Discussion:
count records base on what can be seen
(too old to reply)
Patrick A Tura
2005-02-05 16:47:08 UTC
Permalink
Hi! is there any other way to count records in a table that can be affected
with SET FILTER TO? Reccount() is not affected with SET FILTER TO, it still
giving the same figure even what is showing in the grid is different. I need
to get only the figures that can be seen in the grid not the whole table
when set filter to is being applied..

Thanks,

/patrick
Mike Gagnon
2005-02-05 17:04:39 UTC
Permalink
Count to x
? x
Post by Patrick A Tura
Hi! is there any other way to count records in a table that can be
affected with SET FILTER TO? Reccount() is not affected with SET FILTER
TO, it still giving the same figure even what is showing in the grid is
different. I need to get only the figures that can be seen in the grid not
the whole table when set filter to is being applied..
Thanks,
/patrick
Patrick A Tura
2005-02-05 17:43:58 UTC
Permalink
Thanks a lot for the tips and always being there:-). It works.

/patrick
Post by Mike Gagnon
Count to x
? x
Post by Patrick A Tura
Hi! is there any other way to count records in a table that can be
affected with SET FILTER TO? Reccount() is not affected with SET FILTER
TO, it still giving the same figure even what is showing in the grid is
different. I need to get only the figures that can be seen in the grid
not the whole table when set filter to is being applied..
Thanks,
/patrick
Anders Altberg
2005-02-06 14:02:03 UTC
Permalink
xx = tablealias
SELECT (xx)
x=SET("filter")
SELECT COUNT(*) FROM (table) WHERE &x INTO ARRAY arr
-Anders
Post by Patrick A Tura
Hi! is there any other way to count records in a table that can be affected
with SET FILTER TO? Reccount() is not affected with SET FILTER TO, it still
giving the same figure even what is showing in the grid is different. I need
to get only the figures that can be seen in the grid not the whole table
when set filter to is being applied..
Thanks,
/patrick
Patrick A Tura
2005-02-07 17:26:11 UTC
Permalink
Thank you very much Anders for your quite advance formulation of COUNT()
using
SELECT. I lear something with that way of formulation, it is too
concentrated to me:-)

/patrick
Post by Anders Altberg
xx = tablealias
SELECT (xx)
x=SET("filter")
SELECT COUNT(*) FROM (table) WHERE &x INTO ARRAY arr
-Anders
Post by Patrick A Tura
Hi! is there any other way to count records in a table that can be
affected
Post by Patrick A Tura
with SET FILTER TO? Reccount() is not affected with SET FILTER TO, it
still
Post by Patrick A Tura
giving the same figure even what is showing in the grid is different. I
need
Post by Patrick A Tura
to get only the figures that can be seen in the grid not the whole table
when set filter to is being applied..
Thanks,
/patrick
Wolfgang Schmale
2005-02-13 19:31:12 UTC
Permalink
Count for FilterCondition to nCount
--
------------------------------

Mit freundlichen Güßen aus der Zigarrenstadt

Wolfgang Schmale

------------------------------------------------
Post by Patrick A Tura
Hi! is there any other way to count records in a table that can be
affected with SET FILTER TO? Reccount() is not affected with SET FILTER
TO, it still giving the same figure even what is showing in the grid is
different. I need to get only the figures that can be seen in the grid not
the whole table when set filter to is being applied..
Thanks,
/patrick
Loading...