>Is there a way to verify if a field exist or not. I need this to make sure I don't try to add or remove twice the same field...
If the table is in a DBC, you can check without ever opening the table with
Set Database To mydatabase
llFieldExists = INDBC("mytable.myfield", "Field")For any type of table
USE mytable
llFieldExists = FSize("myfield")>0
llFieldExists = FSize("myfield", "mytableAlias")>0
Insanity: Doing the same thing over and over and expecting different results.
