>Assuming I know the name of a field and if it is numeric or not. With those two values, what would be the best way to extract the length and the decimal value of that field from the field structure?
You can extract the length using FSIZE().
How about this small function to get the decimal?
LPARAMETER tcFldName
LOCAL lcStr
lcStr = ALLT(PADL(&tcFldName,100))
RETURN IIF(AT(".",lcStr) > 0,LEN(RIGHT(lcStr,LEN(lcStr) - AT(".",lcStr))),0)
Bye
Jayesh
- Jayesh