Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Validate Database doesn't fix dbc error
Message
From
17/03/1997 12:42:47
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00024456
Message ID:
00024540
Views:
39
>>When try to I run a particular form, I get an error saying that the database needs to be validated. I have run VALIDATE DATABASE RECOVER and it checks out clean. I've opened all the tables & views, etc., and can't see anything wrong. Any ideas?
>>
>>Thanks,
>>Ross
>
>If it's just one form, then the form may not be reflecting a change you made in a table. Delete the tables and add them back to the Dataenvironment. Check the indexes listed in each table in the form to see if they match the indexes listed in the DBC. Theoretically, every change in the DBC is reflected in all your forms, but I've found occasional glitches, usually when I've changed indexes. Somehow I've managed to add an index which doesn't appear in the DBC. Strange :-(
>
>Barbara

Thanks, Barbara. I found a view that didn't reflect a change made to a table. Apparently VALIDATE DATABASE doesn't check views to see if the update criteria are still valid.

Ross
Previous
Reply
Map
View

Click here to load this message in the networking platform