Getting Number of Columns of Hashed File
Posted: Mon Jun 22, 2009 5:42 am
I am writing a routine , which will get HashedFileName as Input and Check the Values in all columns of it. By default the hashed file will contain 1 row, and i wanted to see all the values of all columns is there in a specified range.
I am writing something like this
And once i get the number of columns i will loop it and read the value and will check whether it is there within our range values.
The Problem i am encountering is, The hashed File which i am giving as input contains 5 columns (3 Keys and 2 Non Keys), DCount (@FM) gives me 2 , where as i need 5 as the Output, what value i have to use for counting the number of columns in the Hashed File, or is there any other way to read the Hashed File and check the number of Column and its values?
I am writing something like this
Code: Select all
OpenPath FilePath:HashFileName TO HashVal
Then
Read Record From HashVal, CurrID
Then
RVal = Record
Print Record
ColCount = DCount(RVal,@FM)
* Print DCount(RVal,@VM) : "@VM Count"
* Print DCount(RVal,@FM) : "@FM Count"
* Print DCount(RVal,@TM) : "@TM Count"
* Print DCount(RVal,@AM) : "@AM Count"
* Print "ColCount" : ColCount
Ans = ColCount
End
End
The Problem i am encountering is, The hashed File which i am giving as input contains 5 columns (3 Keys and 2 Non Keys), DCount (@FM) gives me 2 , where as i need 5 as the Output, what value i have to use for counting the number of columns in the Hashed File, or is there any other way to read the Hashed File and check the number of Column and its values?