Hi Nadya


> If you don't delete tag all for your tables, append process would be slow.

Yes thats true but I only plan to use it with live data on an infrequent basis. My test DBCs dont contain too much data. Actually now that I have written it it seems much faster than I thought it would be.


> Also, your development tables structure could be different from your "live" data tables. Do you want to keep new structures (which you use in Development). If target table and source table have different structures, Append command would append only fields, which are the same in both tables.

This is the behaviour I want in my test data however I will have to be very careful with the live data. I have changed the spec so that it uses SYS(3) to generate a folder name for the OLDDATA. This way I at least get a history of backups in case I mess up.

When we want to clone Database+Tables, we use the program, I sent to you.
There was a reference to program GenerateIndexes(), if you noticed.

> We have an application, called DataDictionary, which allows us to modify existing tables structure, create new tables, clone database, modify indexes, re-generate indexes, pack databases.


Yes I did notice. It meant I would have had to add code to regenerate all my indexes:( I have only been using VFP for less than a year so my libary is still a bit sparse. I will have to sit down and write functionality to do this unless I can find it somewhere. I hate having to hack GenDBC output.


>>BTW how do I send code samples that have all the right editor colors in place like yours do. It looks really nifty (*_*)
>
>I thought, you're quite frequent in UT. :)

It just feels like a long time Nadya because I post so many problems (*_*)

>See the recent thread Visual FoxPro in general Re: A Quick Way to Use mhHTMLCode Thread #478135 for details.

Thanks