>CLOSE DATABASES
>OPEN DATABASE (HOME( ) + 'samples\data\testdata')
>USE customer && Opens Customer table
>
>CLEAR
>FOR gnCount = 1 TO FCOUNT( ) && Loop for number of fields
> ? FIELD(gnCount) && Display each field
>NEXT
>?
>? 'Number of fields: ' + ALLTRIM(STR(gnCount -1))
John,
Field(Exp) returns the name of the field. If you want the data in the feild you need to Evaluate the name as in;
CLEAR
FOR lnCount = 1 TO FCOUNT( )
? EVAKUATE(FIELD(gnCount))
ENDFOR
?
? 'Number of fields: ' + ALLTRIM(STR(gnCount -1))
Hope this gets you in the right direction.