Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wishlist: native VFP views
Message
From
20/12/1999 09:16:17
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00305642
Message ID:
00306093
Views:
90
>>What about the implementation of the 8 relational operators with the same properties as I did describe in the first message ?
>
>List the operators for me, I get Join, Intersection, Difference, and Union. What does your list include.

Look at http://www.utexas.edu/cc/dbms/utinfo/relmod/relmod3.html

The operators are:
UNION
DIFFERENCE
INTERSECTION
PRODUCT
PROJECTION
SELECTION
JOIN
DIVISION

>>What about getting a SQL-select implementation which basicly offers a updatable filtered result, even with joins, so we can use the advantages I mentioned in the first message ?
>
>We have that already with views.

That doesn't have the advantage which I was describing in the original message:
- Changes in the source tables are not reflected inmidiately in the view
- I don't have the benefit of existing indexes of the sourcetables
- the view is independent from the datasource stored as a cursor
- the view is slow because the data must be copied from the datasources
- I can't use the buffering modes NONE and pessimistic row and tablebuffering

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform