This section of Help provides an introduction to the SQL Query language used throughout Filopto. An understanding of the SQL Query language may assist you in maximizing the use of such built-in tools as the Report Designer and Ask a Question.
The SQL Query Language is the fundamental language used by these tools to retrieve the information requested in a query.
SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard Query language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.
Filopto uses this language for creating queries in the Report Manager and Form Manager as well as in the ASK a Question module.
You can view and use and modify the various queries located in the reports and forms in Filopto.
