Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid problems (vertical scroll bar)
Message
From
22/09/2000 04:44:32
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00418975
Message ID:
00419596
Views:
21
>In one case I use a dataenvironment.
>
>e.g. I have 2 cursors named 'company' and named 'scale'
>
>I use Relations between the cursors but it only works when I have set the property 'filter' from 'scale' to '=scale.icomp_nr = company.inr'
>
>Having set the filter property my grid just shows the 'scale' - data of the selected company.
>
>Can I do anything else? Just with relations it shows the scales of every company.


Actually you can do many things :) 'Set filter' despite Rushmore optimization is still slooowwww. A simple one that doesn't even need relations in DE is as follows. Assuming you use customer and orders from testdata (tables dropped in DE but relation is deleted to demonstrate you don't need it - no order is set for orders table though might be one starting with cust_id) :

Put fields from customer.
Put fields from orders as a grid.
*Grid properties
ChildOrder = 'cust_id'
LinkMaster = 'customer'
RelationalExpression = 'cust_id'

That's all :)
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform