>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
Ashish,
First check if you can exclusively use the table. Next check if field is already defined. Other than that above code would work.
Cetin