New SQL Support

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.