Dear Chang,

As per what I understood from your query is that you want to know the no. of fields in specific table , if this the matter. than

than just to know the no. of field is

SELE (tablename)
x = fcount()
?x && x = no. of fields

**** Below is the good example to refer


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))

Regds,
Rajesh