Optimize Property (Visual FoxPro)
Specifies whether the Grid control uses Rushmore optimization. Read/write at design time and run time.
Grid.Optimize [ = lExpr]
Return Value
lExpr
Logical expression specifying if the Grid control uses Rushmore optimization.Setting Description True (.T.)
The Grid control uses Rushmore optimization.
False (.F.)
(Default) The Grid control does not use Rushmore optimization.
Remarks
Applies To: Grid Control
When Rushmore Optimization is enabled by setting the Optimize property to True (.T.), the set of matched records is refreshed during the following operations:
When the Grid is initially populated
When the Grid is activated
When the Grid Refresh Method is called
Note
As with any data manipulation command that can impact Rushmore optimization, you should be aware that actions taken against the Grid's data source could result in behavior that differs from when the Optimize property is set to False (.F.). For example, Rushmore optimization might trigger an implicit TABLEUPDATE to occur for a row buffered cursor. And an error may or may not occur depending on whether the record is blank or whether the cursor is a view.
See Also
Reference
SYS(3054) - Rushmore Query Optimization Level
SET OPTIMIZE Command