Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CodeMine Toolbar Requery button
Message
From
18/09/2002 18:30:43
 
General information
Forum:
Visual FoxPro
Category:
CodeMine
Miscellaneous
Thread ID:
00701003
Message ID:
00702058
Views:
16
>In this case, many of the views will be a match of the data source. Am I going the wrong way ?

Say you have a data source with 50,000 records. You base a view on it. Are you really going to pull 50,000 records over the wire to populate your view? This would be very inefficient indeed.

Normally, you would only be interested in a subset of the original data source. So, it is usual to filter the view to a subset of the data source by a WHERE clause, generally parameterized, so that you can specify a different value for the parameter variable, usually part of the WHERE clause and requery.

Obviously, if the data sources are very small, then I suppose the view could match the data source. However, I think as a general rule, this would not usually happen.

Best
-=Gary
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform