>I'm a little confused on what the validate method in SDT does. Does it do the equivalent of Validate Database Recover (except actually fix the situation)? Sometimes my client blows all the indexes in a table (I think it happens during a crash - the database and the cdx are physically there but when you modi stru the dbf there are no index tags...) Since it happens at the client site, and since FOxpro doesn't support the Recover option within the runtime, this causes problems. I would like to add a button to my system to allow the user to perform the validate method, but I'm not sure exactly what it does... Thanks for the help/clarification.
>
>Sandi Cassidy
>scassidy@canaccount.com
The SDT validation is different the the Validate Database Recover. The SDT NeedUpdate method uses the meta data in the SDT files to compare what is in the DBC. If it finds differences then you run the Update method to update the database to match what is in the SDT meta data files. This includes structure changes, new indexes, dropped indexes, key fields, RI, etc. Part of the SDT validation process does recreate the DBC index file [DCX] as well. That is as close to the Validate Database Recover command as you can get in VFP 6. Now in VFP 7... I know Doug is working really hard on the next version of SDT so it is ready when VFP 7 ships.
Mark McCasland
Midlothian, TX USA