Programmer 7500

home *** CD-ROM | disk | FTP | other *** search

/ Programmer 7500 / MAX_PROGRAMMERS.iso / INFO / CLIPPER / NFTROFF.ZIP / 4.tr < prev next >

Wrap

Text File | 1991-11-21 | 8.8 KB | 695 lines

.de }n .bp .sp .5i .. .wh -.8i }n .sp .5i .po -.4i .ll 7.5i .ps 9 .vs 9 .in 0i .ta 1.63265i .sp 2 .ne 20 .ps +3 .vs +3 FT_FDEC() Return the number of decimals in a numeric (type "N") field\. .br .ta .in 0.08i .ps -3 .vs -3 .sp 2 \fBFT_FDEC() Return the number of decimals in a numeric (type "N") field\. .in 0i .br \l'6.24i' .br .sp .in 0.08i \fBSyntax .sp .in 0.4i \fBFT_FDEC( <xVar> ) -> nDec .sp .in 0.08i \fBArguments .sp .in 0.4i \fB<xVar>\fR is either a field name or ordinal \.DBF position\. .sp .in 0.08i \fBReturns .sp .in 0.4i the number of decimal places in a numeric field\. -1 if field is not type "N", or if other error\. .sp .in 0.08i \fBDescription .sp .in 0.4i FT_FDEC() reports the number of decimal places in a numeric field\. .sp .in 0.08i \fBExamples .sp .in 0.4i .br nDec:= FT_FDEC( "unit_prc" ) .br nDec:= FT_FDEC( 2 ) .br - or - .br nNum:= FT_FNUM( "unit_prc" ) .br nDec:= FT_FDEC( nNum ) .sp .in 0.08i \fBSource:\fR FIELD\.PRG .sp \fBAuthor:\fR Steve Kolterman .in 0i .sp .in 1.5i .ti -1.5i .ta 1.5i .ft B See Also: .ft R FT_FPLACE() , FT_FVALLEN() , FT_FLEN() , FT_FNUM() , FT_FTYPE() , FT_FVAL() .ta 1.63265i .in 0i .sp 2 .ne 20 .ps +3 .vs +3 FT_FEMPTY() Determine if a field is empty, i\.e\., contains no value\. .br .ta .in 0.08i .ps -3 .vs -3 .sp 2 \fBFT_FEMPTY() Determine if a field is empty, i\.e\., contains no value\. .in 0i .br \l'6.24i' .br .sp .in 0.08i \fBSyntax .sp .in 0.4i \fBFT_FEMPTY( <xVar> ) -> lVal .sp .in 0.08i \fBArguments .sp .in 0.4i \fB<xVar>\fR may be either a field name or ordinal \.DBF position\. .sp .in 0.08i \fBReturns .sp .in 0.4i <lVal>, a logical indicating if field <xVar> is empty\. .sp .in 0.08i \fBDescription .sp .in 0.4i FT_FEMPTY() checks for the existence of a value in a field\. .sp .in 0.08i \fBExamples .sp .in 0.4i .br lEmp:= FT_FEMPTY( "unit_prc" ) .br lEmp:= FT_FEMPTY( 2 ) .br - or - .br nNum:= FT_FNUM( "unit_prc" ) .br lEmp:= FT_FEMPTY( nNum ) .sp .in 0.08i \fBSource:\fR FIELD\.PRG .sp \fBAuthor:\fR Steve Kolterman .in 0i .ta 1.63265i .sp 2 .ne 20 .ps +3 .vs +3 FT_FEXIST() Check for the existence of a field\. .br .ta .in 0.08i .ps -3 .vs -3 .sp 2 \fBFT_FEXIST() Check for the existence of a field\. .in 0i .br \l'6.24i' .br .sp .in 0.08i \fBSyntax .sp .in 0.4i \fBFT_FEXIST( <xVar>, <xVal> ) -> lVal .sp .in 0.08i \fBArguments .sp .in 0.4i \fB<xVar>\fR may be either a field name or ordinal \.DBF position\. .sp .in 0.08i \fBReturns .sp .in 0.4i <lVal>, a logical indicating a field\'s existence or lack thereof\. .sp .in 0.08i \fBDescription .sp .in 0.4i FT_FEXIST() enables existence checking before proceeding with other operations\. .sp .in 0.08i \fBExamples .sp .in 0.4i .br lExi:= FT_FEXIST( "unit_prc" ) .br lExi:= FT_FEXIST( 2 ) .br - or - .br nNum:= FT_FNUM( "unit_prc" ) .br lExi:= FT_FEXIST( nNum ) .sp .in 0.08i \fBSource:\fR FIELD\.PRG .sp \fBAuthor:\fR Steve Kolterman .in 0i .sp .in 1.5i .ti -1.5i .ta 1.5i .ft B See Also: .ft R FT_FVALLEN() , FT_FLEN() , FT_FDEC() , FT_FNUM() , FT_FTYPE() , FT_FVAL() .ta 1.63265i .in 0i .sp 2 .ne 20 .ps +3 .vs +3 FT_FLEN() Return a field\'s length\. .br .ta .in 0.08i .ps -3 .vs -3 .sp 2 \fBFT_FLEN() Return a field\'s length\. .in 0i .br \l'6.24i' .br .sp .in 0.08i \fBSyntax .sp .in 0.4i \fBFT_FLEN( <xVar> ) -> nLen .sp .in 0.08i \fBArguments .sp .in 0.4i \fB<xVar>\fR is either a field name or ordinal \.DBF position\. .sp .in 0.08i \fBReturns .sp .in 0.4i the length of the specified field\. -1 if error\. .sp .in 0.08i \fBDescription .sp .in 0.4i FT_FLEN() reports the length of any \.DBF field\. .sp .in 0.08i \fBExamples .sp .in 0.4i .br nLen:= FT_FLEN("unit_prc") .br nLen:= FT_FLEN( 2 ) .br - or - .br nNum:= FT_FNUM( "unit_prc" ) .br nLen:= FT_FLEN( nNum ) .sp .in 0.08i \fBSource:\fR FIELD\.PRG .sp \fBAuthor:\fR Steve Kolterman .in 0i .sp .in 1.5i .ti -1.5i .ta 1.5i .ft B See Also: .ft R FT_FPLACE() , FT_FVALLEN() , FT_FDEC() , FT_FNUM() , FT_FTYPE() , FT_FVAL() .ta 1.63265i .in 0i .sp 2 .ne 20 .ps +3 .vs +3 FT_FNUM() Return a field\'s ordinal position given the field name\. .br .ta .in 0.08i .ps -3 .vs -3 .sp 2 \fBFT_FNUM() Return a field\'s ordinal position given the field name\. .in 0i .br \l'6.24i' .br .sp .in 0.08i \fBSyntax .sp .in 0.4i \fBFT_FNUM( <cVar> ) -> nNum .sp .in 0.08i \fBArguments .sp .in 0.4i \fB<cVar>\fR must be a valid field name\. .sp .in 0.08i \fBReturns .sp .in 0.4i the ordinal position of the field\. 0, if a non-character value is passed or field <xVar> does not exist\. .sp .in 0.08i \fBDescription .sp .in 0.4i In 5\.01, FT_FNUM() was superseded by FieldPos()\. Included here for those who already coded FT_FNUM() calls\. .sp .in 0.08i \fBExamples .sp .in 0.4i nNum:= FT_FNUM( "unit_prc" ) .sp .in 0.08i \fBSource:\fR FIELD\.PRG .sp \fBAuthor:\fR Steve Kolterman .in 0i .sp .in 1.5i .ti -1.5i .ta 1.5i .ft B See Also: .ft R FT_FPLACE() , FT_FVALLEN() , FT_FLEN() , FT_FDEC() , FT_FTYPE() , FT_FVAL() .ta 1.63265i .in 0i .sp 2 .ne 20 .ps +3 .vs +3 FT_FPLACE() Write a new value to a field\. .br .ta .in 0.08i .ps -3 .vs -3 .sp 2 \fBFT_FPLACE() Write a new value to a field\. .in 0i .br \l'6.24i' .br .sp .in 0.08i \fBSyntax .sp .in 0.4i \fBFT_FPLACE( <xVar>, <xVal> ) -> xVal .sp .in 0.08i \fBArguments .sp .in 0.4i \fB<xVar>\fR is either a field name or ordinal \.DBF position\. .sp .in 0.08i \fBReturns .sp .in 0.4i <xVal>, the FT_FPLACE()d value\. NIL if error\. .sp .in 0.08i \fBDescription .sp .in 0.4i FT_FPLACE() writes a new value to a specified field of *ANY* Clipper-valid type\. In conjunction with the FIELDPLACE UDC (in FT_FIELD\.CH), it constitutes a fully capable alternative to REPLACE\. .sp .in 0.08i \fBExamples .sp .in 0.4i .br xVal:= FT_FPLACE( "unit_prc", 15\.73 ) .br xVal:= FT_FPLACE( 2, 15\.73 ) .br - or - .br nNum:= FT_FNUM( "unit_prc" ) .br xVal:= FT_FPLACE( nNum,15\.73 ) .sp .in 0.08i \fBSource:\fR FIELD\.PRG .sp \fBAuthor:\fR Steve Kolterman .in 0i .sp .in 1.5i .ti -1.5i .ta 1.5i .ft B See Also: .ft R FT_FVALLEN() , FT_FLEN() , FT_FDEC() , FT_FNUM() , FT_FTYPE() , FT_FVAL() .ta 1.63265i .in 0i .sp 2 .ne 20 .ps +3 .vs +3 FT_FTYPE() Return a field\'s type, given field name or ordinal position .br .ta .in 0.08i .ps -3 .vs -3 .sp 2 \fBFT_FTYPE() Return a field\'s type, given field name or ordinal position .in 0i .br \l'6.24i' .br .sp .in 0.08i \fBSyntax .sp .in 0.4i \fBFT_FTYPE( <xVar> ) -> cType .sp .in 0.08i \fBArguments .sp .in 0.4i \fB<xVar>\fR is either a field name or ordinal \.DBF position\. .sp .in 0.08i \fBReturns .sp .in 0.4i the type of field: character (C), numeric (N), date (D), logical (L), or memo (M)\. "U", if NIL\. .sp .in 0.08i \fBDescription .sp .in 0.4i FT_FTYPE() reports the type ("C","N","D","L","M") of any \.DBF field\. .sp .in 0.08i \fBExamples .sp .in 0.4i .br cType:= FT_FTYPE( "unit_prc" ) .br cType:= FT_FTYPE( 2 ) .br - or - .ta 0.64i .br nNum:= FT_FNUM( "unit_prc" ) .br .ta .br cType:= FT_FTYPE( nNum ) .sp .in 0.08i \fBSource:\fR FIELD\.PRG .sp \fBAuthor:\fR Steve Kolterman .in 0i .sp .in 1.5i .ti -1.5i .ta 1.5i .ft B See Also: .ft R FT_FPLACE() , FT_FVALLEN() , FT_FLEN() , FT_FDEC() , FT_FNUM() , FT_FVAL() .ta 1.63265i .in 0i .sp 2 .ne 20 .ps +3 .vs +3 FT_FVAL() Return the value of a field\. .br .ta .in 0.08i .ps -3 .vs -3 .sp 2 \fBFT_FVAL() Return the value of a field\. .in 0i .br \l'6.24i' .br .sp .in 0.08i \fBSyntax .sp .in 0.48i \fBFT_FVAL( <xVar> ) -> xVal .sp .in 0.08i \fBArguments .sp .in 0.4i \fB<xVar>\fR is either a field name or ordinal \.DBF position\. .sp .in 0.08i \fBReturns .sp .in 0.4i value (contents) of the specified field\. NIL, if error\. .sp .in 0.08i \fBDescription .sp .in 0.4i FT_FVAL() reports the value (contents) of any \.DBF field\. .sp .in 0.08i \fBExamples .sp .in 0.4i .br xVal:= FT_FVAL( "unit_prc" ) .br xVal:= FT_FVAL( 2 ) .br - or - .br nNum:= FT_FNUM( "unit_prc" ) .br xVal:= FT_FVAL( nNum ) .sp .in 0.08i \fBSource:\fR FIELD\.PRG .sp \fBAuthor:\fR Steve Kolterman .in 0i .sp .in 1.5i .ti -1.5i .ta 1.5i .ft B See Also: .ft R FT_FPLACE() , FT_FVALLEN() , FT_FLEN() , FT_FDEC() , FT_FNUM() , FT_FTYPE() .ta 1.63265i .in 0i .sp 2 .ne 20 .ps +3 .vs +3 FT_FVALLEN() Return the length of the value in a field\. .br .ta .in 0.08i .ps -3 .vs -3 .sp 2 \fBFT_FVALLEN() Return the length of the value in a field\. .in 0i .br \l'6.24i' .br .sp .in 0.08i \fBSyntax .sp .in 0.4i \fBFT_FVALLEN( <xVar> ) -> nVlen .sp .in 0.08i \fBArguments .sp .in 0.48i \fB<xVar>\fR is either a field name or ordinal \.DBF position\. .sp .in 0.08i \fBReturns .sp .in 0.48i the length of the value in a specified field\. -1 if error\. .sp .in 0.08i \fBDescription .sp .in 0.48i FT_FVALLEN() reports the length of the value in any \.DBF field\. .sp .in 0.08i \fBExamples .sp .in 0.48i .br nVallen:= FT_FVALLEN("unit_prc") .br nVallen:= FT_FVALLEN( 2 ) .br - or - .ta 0.8i .br nNum:= FT_FNUM( "unit_prc" ) .br .ta .br nVallen:= FT_FVALLEN( nNum ) .sp .in 0.08i \fBSource:\fR FIELD\.PRG .sp \fBAuthor:\fR Steve Kolterman .in 0i .sp .in 1.5i .ti -1.5i .ta 1.5i .ft B See Also: .ft R FT_FPLACE() , FT_FLEN() , FT_FDEC() , FT_FNUM() , FT_FTYPE() , FT_FVAL()