>Hello,
>
>We are constantly updating our software to our clients through pcANYWHERE. This works fine for the code, but poses big problems if I make any changes to the tables.
>
>What I do now is download their table, modify it on my computer in VFP, and upload it back to them. With large tables, this can be time consuming.
>
>I would like something that I can install on their computer to modify the tables locally. By putting a browse command in the code, I now have the ability to change the data directly, but it doesn't allow me to change the table itself.
>
>I want to be able to do the following things: Add/delete fields, add/delete indexes, and pack the table.
>
>Is there a program that does this already? If not, do you have any ideas on how to go about writing such a thing? The pack command I think I can handle. :) But I have no idea how to modify the structure programatically.
>
>Thanks,

Hi Michelle,
There are more than one ways to accomplish this. But I think SQL "create table" is the easiest. For an example run gendbc (do home()+"tools\gendbc\gendbc") with one of your databases. Check the code created.
Also check these :
-Create table
-Copy to
-Alter table
-Drop table
-Delete tag
etc
BTW you could also use "modify structure" on runtime if have exclusive access.
Cetin