Difference between revisions of "IN ARRAY()"

From Lianjapedia
Jump to: navigation, search
 
(One intermediate revision by one other user not shown)
Line 22: Line 22:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Array Processing]]
 
 
[[Category:Array Processing Functions]]
 
[[Category:Array Processing Functions]]
 +
[[Category:Lianja VFP Extensions]]
 +
[[Category:VFP Function Extensions]]

Latest revision as of 06:21, 10 December 2012

Purpose

Function to search an array for an expression

Syntax

IN_ARRAY(<exp>, <array>)

See Also

AADD(), AAVERAGE(), ACOPY(), ADEL(), ADESC(), ADIR(), AELEMENT(), AFIELDS(), AFILL(), AINS(), ALEN(), AMAX(), AMIN(), APPEND FROM ARRAY, ARRAY(), ASCAN(), ASIZE(), ASORT(), ASTORE(), ASTRING(), ASUBSCRIPT(), ASUM(), COPY TO ARRAY, DECLARE, DIMENSION, GATHER, LOCAL, PRIVATE, PUBLIC, RELEASE, RESTORE, SAVE, SCATTER, SET EXACT

Description

The IN_ARRAY() function searches the array <array> for the expression specified in <exp>. The expression may consist of any data type. It returns .T. (true) if the expression is located, or .F. (false) if not found.

Example

open database southwind
use example
declare names[reccount(),1]
copy to array names fields start_date
valid_date = in_array({02/09/2000}, names)