Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC for views
Message
From
22/09/2004 02:39:00
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00944541
Message ID:
00944868
Views:
38
Hi Victor,

>hmmmmmm...well I learn something new every day. Still though I would have to ponder the idea of putting the dbc in the exe. I suppose a big part of determining if that's the way to go would depend on how often your tables (and thus your views) are going to be changing. Plus it would be a good idea not to have any "Select *" in any views since that forces you to rebuild it if the table structure changes.

That's true regardless of the solution you choose.

>I dunno - seems like alot of potential headaces. I like the idea of being able to update views without having to recompile - plus I don't even have to kick the users out of the application to do it.

Personally it is no headache, as I work with software that had to be installed at many clients. There simply is not any reason for them to change the database structure without us validating and making a new build. This is really a 5 minute job.

But of course if you attach much value to beeing able to change the view definitions, it is another matter.

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform