Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Views vs. SQL-Pass through
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00353636
Message ID:
00355598
Views:
20
>Hi all,
>Hi Bob,
>
>Sorry to interrupt, but i use your phylosophy and i'm having a problem. When i have new fields to the table and i need to re-create the remote view, VFP hangs the system. All i do is, DELETE the remote view, change the table and create a new remote view with that new code... when i try to re-create the view, VFP blocks out and don't do anything more.
>
>Ever happen to you?
>
>Ricardo

Hey Ricardo,

It used to happen all the time to me until I finally realized that the view designer can be more of a pain than it is worth. What I now do when starting a new project is to design a few basic views with the view designer then use GenDBCX to generate a program I can use to create the dbc. Then, I cut out all the code used to recreate the views. From that point on, I only create views programatically. This is a little more overhead, but has the added bonus of being able to recreate all your views whenever you need to. Or if you maintain the entire DBC recreation DBC you can re-create your entire DBC easily.

Michael G. Emmons
memmons@nc.rr.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform