Home

SuperFastDistinct!

    Limitations
    3rd Party
    Running
    Examples
    Need For Speed
    BenchMark
    Graphs
    How Fast

Download

Order Form

SuperFastDistinct!

Examples  

 Retrieve all the distinct Common_Name values from Biolife and put them into ComboBox1.

    

NumDistinctValues := SuperFastDistinct(


 

BioLifeTable,
'Common_Name',
ComboBox1.Items);


Retrieve all the distinct LastName;FirstName values from EmployeeTable and put them into a table called LkUpTable. The LkUpTable fields will be created automatically because 'BuildOutputTable' is one of our options. This also builds a primary index on the fields LastName;FirstName in LkUpTable to ensure any lookups we do on this table later on are as fast as possible.


NumDistinctValues := SuperFastDistinct(


 

EmployeeTable,
'LastName;FirstName',
LkUpTable,
'BuildOutputTable');



Get the distinct values of the current table index and put them into LkupTable.

EmployeeTable.IndexFieldNames := 'LastName;FirstName';

NumDistinctValues := SuperFastDistinct(


 

EmployeeTable,
EmployeeTable.IndexFieldNames,
LkUpTable,
'BuildOutputTable');



Let's just count the number of distinct LastName/FirstName values in the EmployeeTable.Because the OutObject parameter is missing, none of the distinct values will be returned and only the count will be returned.

NumDistinctValues := SuperFastDistinct(
 

EmployeeTable,
'LastName;FirstName');



If we want just the number of distinct LastName values then we use just the first field of the same index.

NumDistinctValues := SuperFastDistinct(
 

EmployeeTable,
'LastName');

Contact webmaster with questions regarding this site.
copyright ©1997-2006 by Grebar Systems Inc. All rights reserved.

Site updated Friday, April 21, 2006