Performing ASCAN on two fields !? 1

[mensudb]

Hi,

I have an array with three fields. I would like to run ASCAN on two fields. Is that possible with this function?

Thanks,

Mensud

 

[Stella740pl]

You mean, you have a 2-dimensional array with 3 columns?

You can perform 2 separate ASCAN(), and combine the results with OR, or AND, or whatever you need.

ASCAN allows you to specify starting and ending elements for the search, so you can use this to define your columns.
According to VFP6 Help,

ASCAN(ArrayName, eExpression [, nStartElement [, nElementsSearched]])
...
[u]Note[/u]   You can refer to an element in a two-dimensional variable array in one of two ways. The first method uses two subscripts to specify the row and column position of the element in the array; the other method uses an element number. This function and others that manipulate two-dimensional arrays require element numbers (nStartElement and nElementsSearched). Use AELEMENT( ) to return the element number from row and column subscripts in a two-dimensional array.

I think this is what you need.

Stella

 

[mensudb]

That is what I need.
Thanks.