Difference between revisions of "IN ARRAY()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
|||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to search an array for an expression | Function to search an array for an expression | ||
− | |||
==Syntax== | ==Syntax== | ||
IN_ARRAY(<exp>, <array>) | IN_ARRAY(<exp>, <array>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[AADD()]], [[AAVERAGE | + | [[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== | ==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. | 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== | ==Example== | ||
Line 24: | Line 20: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[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
Contents
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)