General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Need advise restoring vfp 8.0 dbf to database
guys,
i have a database containing about a bunch of dbfs. the dbfs have field names greater than 10 characters, default values, triggers and joins. here is the problem i have:
once in a while a table gets corrupted. so what i end up doing is
1. set tablevalidate to 0
2. copy the table to a backup
3. remove the corrupt table from the database
4. rename and then add the backup table
5. rename all the fields and add the default values, triggers, etc.
as you can see step 5 is a pain in the neck. is there a way i can do this more efficiently?
thanks,
nancy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only