ADEL()

From Recital Documentation Wiki
Revision as of 15:35, 1 June 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Class

Array Processing


Purpose

Function to delete an element from an array


Syntax

ADEL(<array>,<expN>[,2])


See Also

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


Description

The ADEL() function deletes the element at position <expN> of the specified <array>. All elements higher than the deleted element will be shifted down and the last element in the <array> will become .F.. The total number of elements in the <array> will remain the same.

For two-dimensional arrays, the <expN> refers to an entire row of elements, rather than an individual element. If the '2' parameter is included, the <expN> refers to an entire column of elements.


Example

element_no = ascan(flist,"New information")
// If element exists
if m.element_no > 0
    adel(flist,m.element_no)
endif
 
//Another Example
set compatible to foxpro
dimension array1(3,3)
array1(1,1) = "one"
array1(1,2) = 1
array1(1,3) = ctod("01/01/2001")
array1(2,1) = "two"
array1(2,2) = 2
array1(2,3) = ctod("02/02/2002")
array1(3,1) = "three"
array1(3,2) = 3
array1(3,3) = ctod("03/03/2003")
//Delete row 2
adel(array1,2)
//Delete column 1
adel(array1,1,2)


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer