Tag Archives: BLANKFIELD()

SP Expression Functions

Posted on by vivaclipper 
 FIELDLENX()    Returns length of field
 EXPBLOCK()     Returns a codeblock to evaluate an expresson
 FIELDTYPEX()   Returns type of field
 FIELDPOSX()    Returns position of field named in expression
 FIELDDECX()    Returns decimals of field
 PARSFIELD()    Exracts the name of the field from an expression
 BLANKREC()     Blanks out a record
 PARSALIAS()    Exracts the name of the alias from an expression
 WORKBLOCK()    Returns a set-get block for field named in an expression
 BLANKFIELD()   Returns a blank value corresponding to a field
 ISBLANKREC()   Determines if a record is blank
 ISFIELD()      Determines if an expression is the name of a field
 ISTHISAREA()   Determines if expression is the name of a field in this area

SP_BLANKFIELD

Posted on by vivaclipper 
BLANKFIELD()

  Short:
  ------
  BLANKFIELD() Returns a blank value corresponding to a field

  Returns:
  --------
  <expBlank> => blank value, corresponding to a field

  Syntax:
  -------
  BLANKFIELD(cField)

  Description:
  ------------
  <cField> is the name of the field. Can also include
  the alias

  A blank value is returned:

  For: Character           Spaces the length of the field
       Numeric             Zero
       Logical             .f.
       Date                Blank date
       Memo                ""

  Examples:
  ---------
   // fill an array with matching blanks for the record - good
   // for an ADD routine

   aAdds := array(fcount())
   for i = 1 to fcount()
     aAdds[i] := BLANKFIELD(field(i))
   next

  Source:
  -------
  S_BLANKS.PRG