>>I've looked at Help on ALTER TABLE and I don't see if it requires exclusive access or not.
>
>Yes it is
>
Is there any other way to change the structure of the existing table?
>
>>Also, does your code require to have the table opened? And why do we have INDBC(.. ) for the field? What good can the value return if it doesn't tell which table?
>
>
>I don't know:-)
I liked Hugo's solution with empty(field('name','table'))
If it's not broken, fix it until it is.
My Blog