Querying is one of the main operations when working with 4D databases. Each time a query is performed, the amount of time that 4D takes to perform the task is determined by the total number of records in a table. If the total number of records is large, the user will have to wait a good amount of time before getting the results. To database users, getting quick results is a high priority. Fortunately, 4D offers the ability to create sets, relate them to the current selection, and store, load, and clear sets.
This Technical Note discusses some of the advantages of using sets. It also demonstrates how to manipulate record selections using sets.
Download Complete Tech Note and Example: Windows | Mac