Fetching record count

[Pramod Kadur]

Using borland c++, how can we fetch the record count in the following case:
Suppose in XY table,

First column
A
B
C
D
E
F
G
H
.
.
.

Second column
100
100
100
100
333
222
444
666
.
.
.

Here i need to get record count as 4, after seeking record for second column field =100

Thanks in advance

[Ganon11]

Could you please explain the situation a little more? For instance, are these values being stored in an array? In two parallel arrays? In a two dimensional array? In a class?

[Pramod Kadur]

Could you please explain the situation a little more? For instance, are these values being stored in an array? In two parallel arrays? In a two dimensional array? In a class?

I have a table in foxpro database. Suppose there are four column(say column names=>first, second, three and four). The index is on the fourth column. This fourth column contains values like 100,100, 100, 100, 200, 400, 400, 500, 500, 500 etc.

Here after opening this table, i need to get the record count for say to value=100(fourth coulmn), so here it should return as 4. How to fetch this record count?. I am using borland c++ and foxpro database.

Thanks in advance.