SP_ISINLOOK

ISINLOOK()

  Short:
  ------
  ISINLOOK() Checks for existence of a value in a lookup dbf

  Returns:
  --------
  lFound  => value was found

  Syntax:
  -------
  ISINLOOK(expCurrent,nArea,[bCompare],[lBlankOk],[cMsg])

  Description:
  ------------
  Looks for <expCurrent>, and expression of any type,
  in the workarea indicated in <nArea>.

  [bCompare]  - Normally a SEEK would be done, but if
  [bCompare] (a codeblock ) is passed, this acts as a LOCATE FOR ,
  as in LOCATE FOR eval(bCompare)

  [lBlankOk] - If this is false (the default), and
  <expCurrent> is empty, an automatic false is returned.

  [cMsg] - If this is passed, and the value is not
  found ,or is blank and <lBlankOk> is false, this message is
  displayed. Default is no message

  Examples:
  ---------
   @3,0 GET V3 WHEN  !ISINLOOK(v3,5,nil,.f.,"Not Valid or is blank")

   @4,0 GET V4 VALID ;
     ISINLOOK(v4,5,{||adbf->company},.f.,"Not Valid or is  blank")

  Source:
  -------
  S_INLOOK.PRG

 

2 responses to “SP_ISINLOOK

  1. Pingback: SP Lookup Functions | Viva Clipper !

  2. Pingback: SP Functions | Viva Clipper !

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.