The Synergy Select API allows you to retrieve specific data from your Synergy DBMS files based on a set of relational criteria. The Synergy select API class objects are in the Synergex.SynergyDE.Select namespace.
Understanding the Synergy Select API
Synergex.SynergyDE.Select.AlphaEnumerator - Enumerator class for a Select
Synergex.SynergyDE.Select.Event - Event class onLock method override
Synergex.SynergyDE.Select.From - Identify file to select from and define record layout
Synergex.SynergyDE.Select.GroupBy - Group selection results (case sensitive)
Synergex.SynergyDE.Select.JoinSelect - A Select object after a Join method is applied
Synergex.SynergyDE.Select.NoCaseGroupBy - Group selection results (case insensitive)
Synergex.SynergyDE.Select.NoCaseOrderBy - Order a selection (case insensitive)
Synergex.SynergyDE.Select.NoCaseWhere - Define selection criteria (case insensitive)
Synergex.SynergyDE.Select.On - Provide Join condition and additional filter criteria
Synergex.SynergyDE.Select.OrderBy - Order a selection (case sensitive)
Synergex.SynergyDE.Select.RestrictedAlphaEnumerator - Base enumerator class for Select
Synergex.SynergyDE.Select.RowEnumerator - The enumerator for a Join
Synergex.SynergyDE.Select.Rows - Access record sets returned by each Join iteration
Synergex.SynergyDE.Select.Select - Primary class that supports SQL-like data selection
Synergex.SynergyDE.Select.Sparse - Specify a partial record for network performance
Synergex.SynergyDE.Select.Where - Class containing methods and operators for Select expression processing
