>>What is exactly the line on which you have the error?
>>
>>>Hi All,
>>> I seem to be getting a 'brain cramp' today. < g >
>>>
>>>I have the following code in my program. lnFound is greater then 0 and I can see the field in the table, and in the array, but I get the above message [] when I run the program.
>>>
>>> lnFound = ASCAN(aFieldArray, "CONTRACT")
>>> IF lnFound > 0
>>> ALTER TABLE 'service' ;
>>> DROP COLUMN 'CONTRACT'
>>> ENDIF
>>>
>>>
>>>Any Ideas?
>>>
>>>TIA
>>>Beth
>
>sorry, the Alter table is the line that the error happens.
Are you sure that aFieldArray(lnFound)=="CONTRACT" ?
What if you use the plain one line:
ALTER TABLE service DROP COLUMN CONTRACT