>>>I am looking for suggestions on backup procedures to include in an application. Ideally, it would need to include compression and flexibility regarding files to backup and where they will be backed up to.
>>>
>>>Thanks in advance.
>>
>>I use DynaZip. Works great with VFP and comes with sample VFP code to get you started. Just remember that open files will not be able to be included in this kind of backup [and most other backup methods as well].
>
> One way to get around the open file problem is to create a function that will SELECT * FROM all your tables to a backup area. Then you can zip the resulting tables. This way you never have to worry about the file being open.
>
>
>Wayne
Just wandering, shouldn't it copy the DBC as well - I think that Copy To will leave the copied tables without long names and stuff, so if you simply restore from these tables, I'm not sure what you'd get, or even if you just create empty new tables and append from unzipped tables... I think it should have some Copy .... Database ... clause. Ideally, a good way would then be to scan through all tables in a .dbc and
copy to ("backup\"+juststem(dbf())) with cdx database ("backup\"+juststem(dbc())