I apologize for some recent posting about the following:
====================================
dim tbl as p
tbl.open("service")
ERROR: Property is write only
=============================================
Onviously I should have used tbl = table.open("service")
On the other hand I do have a problem which puzzles me.
table: service.dbf (No set is involved)
field in table: wch, a character field of size 1, wch contains only Y's and N's
There are 32 records of which 3 are Y's and 29 are N's
On a report based solely on "service.dbf", I created a calculated field
in the report footer which is supposed to count N's ,ie count(wch="N"). The
calculated field genie accepts wch="N" as a valid expression. The report
shows a count of 32 instead of 29.
The description of the count function provides two examples based on a set.
There is nothing I can find that deals with my "simple" case.
Since this is not working I created a numerical field, wch2, with a 1
where wch has N and 0 where wch has Y.
Again, the count function, ie count(wch2=1) did not work, Since in this
case the total of wch2 is equivalent to the count I want. I used
the total function.
There is probably something simple that I am not doing to make the
count function work for me.
But what is it?
TIA
A calculated field based on wch2 works fine. count(wch2=1) yields 29 correctly.
====================================
dim tbl as p
tbl.open("service")
ERROR: Property is write only
=============================================
Onviously I should have used tbl = table.open("service")
On the other hand I do have a problem which puzzles me.
table: service.dbf (No set is involved)
field in table: wch, a character field of size 1, wch contains only Y's and N's
There are 32 records of which 3 are Y's and 29 are N's
On a report based solely on "service.dbf", I created a calculated field
in the report footer which is supposed to count N's ,ie count(wch="N"). The
calculated field genie accepts wch="N" as a valid expression. The report
shows a count of 32 instead of 29.
The description of the count function provides two examples based on a set.
There is nothing I can find that deals with my "simple" case.
Since this is not working I created a numerical field, wch2, with a 1
where wch has N and 0 where wch has Y.
Again, the count function, ie count(wch2=1) did not work, Since in this
case the total of wch2 is equivalent to the count I want. I used
the total function.
There is probably something simple that I am not doing to make the
count function work for me.
But what is it?
TIA
A calculated field based on wch2 works fine. count(wch2=1) yields 29 correctly.
Comment