>>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'   && error line here
>>>  ENDIF  &&  IF lnfound > 0
>>>

>>>
>>>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