We want to update our package developed in Visual Foxpro 6.0 from Version 6.0 to 6.1

6.1 version will have some new features asked by the user.

We are using Free tables in our package.

Now my problem is that some of the structure of tables are changes. Some new columns are addes, some columns width is increased and some new tables are added.

My users are all accross the country and I want that Instead of giving them full new CD with full installable program. I want to give only one EXE file.

I am calling one procedure in the begining of my main prpgram which does the following thing.

on error do nothing
alter table consumer add column email c(30)
alter table consumer add column lastmod d(8)
.....

proc nothing
retu

Is the above code ok ?
My application is a multiuser application.
Is it ok to check everytime the user runs the exe to modify the table as shown above ? Will it corrupt the .DBF or .CDX file ?

Is there any better solution ? Pl. Help


Thanks in Advance

Regards

Ashish Patel