>Have a grid located on a form which as it's datasource has child records. The original devloper used the dreaded LinkMaster property to bind the FK in the child to the PK in the parent. We need to sort the grid by a column other than the FK value. Setting ChildOrder in the grid properties sheet does nothing, and manually re-ordering the grid loses the relationship between child/parent. We have tried unbinding the grid and manually populating by a parameterized view and by cursor, and the speed difference is tremendous. How do you re-sort a grid which is bound, using the Linkmaster property? Child table has 7,000,000 records.
A parameterized view works well for me. Perhaps the query expression isn't optimized? (See FAQ #8109 for some ideas). OTOH, the parameterized view will also be slow if VFP has to fetch many records for one specific key value.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)