Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore / set filter / view
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00117431
Message ID:
00119376
Views:
47
>>>Have you heard of anything that would help me with the following:
>>> I have a couple of Tables, upon which are based almost a dozen Views and 5 or 6 Forms. I recently had to change the structure of the Tables. As a result, I had to rebuild from scratch, each View. But that was just the obvious ripple. The change to the Tables involved adding a couple of fields. These fields were for behind the scences stuff and did not need to be on any of the Forms. Nothing that gets displayed or used by the Forms was altered. Even though I had removed the Views from the Database, and reCreated them (via the wizard), and I removed them from the Forms and reAdded them.... Running the Forms would result in an illegal operation!
>>>
>>> I had to go into each field that had a record/control source referring to one of these views, and RESET TO DEFAULT and then reconnect each field.
>>>
>>>Have you heard of anything that would help me with something like that?
>>>
>>
>>That's the price you pay for using bound interface. Unbound interface relieves all these problems tremendously.
>-----------------------------
>I'm willing to learn...
>What else can you tell me about this. So far most of my controls are bound. Most of my unbound controls are there to "kick-Start" the form or to be used for requery of parameterized views.
>
>While unbound controls may help avoid what happened to me this time, isn't there a down side to them as well?

Everything is trade-off. Unbound controls mean coding of mechanizm to populate them.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform