I have a program I am working on. In the program, I use the alter table command to add fields, change lengths, and rename the field. My question is... Is there a way to check for a field that is already there so that when you run the program you don't get the "field already exists or duplicate field" and just skip that line so the user doesn't have to keep hitting ignore. Mabye to clarify a little better, You run the program and it goes and adds all the fields you need, then you have to re-run it for some reason but the structure of the database already has the fields you want to add because you ran the program already, I want to be able to just run the program without having to hit ignore, rather than removing those fields prior to running the program so I dont get that message. Any help would be greatly appreciated.
Thanks in advance,
Rene
Thanks in advance,
Rene