Previous Next

MaxDataGuess property

(Windows only; GUI for .NET only)
An estimate of the number of records that a query will return. The property’s default value is zero.
Data type:
Access:
Applies to:
The MaxDataGuess property offers a time-saving alternative for a ProBindingSource that binds to a query with a large result set. Some .NET controls must know the number of records in the result set when they initialize. By default, the ProBindingSource counts the records by reading the records in the query’s result set, which can be time-consuming for large result sets. Setting this property provides the .NET control with an estimated value to bypass the counting process.
Because the .NET control used an estimated number when it visualized, you might see it readjust as the ProBindingSource’s Count property develops a more accurate count of the records. For example, you might notice the vertical scrollbar thumb of a grid changing size to more accurately reflect the number of displayed records.
When using this property, remember the following:
*
*
*
*
The following code snippet shows the correct order for using the MaxDataGuess property:
 
DEFINE VARIABLE rBindS AS Progress.Data.BindingSource NO-UNDO.
DEFINE VARIABLE hQuery AS HANDLE                      NO-UNDO.
 
ASSIGN
  rBindS              = NEW Progress.Data.BindingSource()
  rBindS:MaxDataGuess = 200000.
 
CREATE QUERY hQuery.
hQuery:SET-BUFFERS(BUFFER Customer:HANDLE).
hQuery:QUERY-PREPARE("FOR EACH Customer NO-LOCK").
hQuery:QUERY-OPEN().
 
rBindS:Handle = hQuery.
See also:

Previous Next
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.