Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fixing DBC
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00445219
Message ID:
00445312
Views:
14
Francisko,
You might want to download EView by Erik Moore from the Files section here. When you've changed the base tables opening the view(s) in EView will give you a message about the base files changing. They give you an option to let EView update the view, and I've found it works great even on views with multiple JOINs which can't be opened in the VFP View Designer.

HTH
Barbara

>I have a couple of Tables and Views inside a DBC. I need to modify some fields in that tables and after that my views didn't open/work any more because the reference inside it are wrong. So I create a little program that opens the DBC file as a table and replace the name of the fields related to that view and also the code inside the property field of that each views.
>I compile the database and now when I open the database and run the views, works fine. But When I try to validate the DBC with "Validate Database" I get a bunch of errors. Is like the Property (Memo) Field was no recompiled.
>
>I read that COMPILE DATABASE compile only the Stored Procedures in the DBC. What about the Property Memo Field of each object?
>Is there another way or command to do it?
>
>Regards,
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform