Silicon Office provides support for SQL (Structured Query Language) queries via a special object, the SQL Object.

SQL is a standard language used to work with database systems, often in a large network situation. The main strength of SQL is that it can be used to select only a small "result set" of records from the database which match your criteria, thus avoiding excess network traffic. It can also be useful for selecting ordered results for reports or statistical calculations. If the server allows, SQL can even be used to create new files or alter the structure of existing files.

Here are some of the key features of SQL.

• You can dynamically sort records in memory without the need for sorting the entire database or using multiple key fields or indexes.
• You can select records based on matching multiple fields from multiple data files with multiple values.
• Data from different tables, or data files can be merged together dynamically in memory to be maniplulated as one table/data file.
• SQL allows you to perform sophisticated record selection without a single line of program code.