FIELDNUM() Determines the field number for a specific field in a database file ------------------------------------------------------------------------------ Syntax FIELDNUM(<cFieldName>) --> nFieldNumber Argument <cFieldName> Designates to the field name. Returns FIELDNUM() returns the number of the data field. Description FIELDNUM() is the exact opposite of the CA-Clipper FIELD() function. Use this function when you need a data field number instead of the data field name. FIELDNUM() determines if a symbol name pertains to a data field or a memory variable (see Examples). Note . If a data field with the name <cFieldName> is not available, the function returns a value of 0. Example Is it a field or a variable? IF FIELDNUM("cName") > 0. REPLACE cName WITH UPPER(cName). ELSE. cName := UPPER(cName). ENDIF
See Also: FCOUNT, FIELDNAME, FIELDTYPE, FIELDSIZE, FIELDDECI, PAD, STR, DBF Structure