The SQL form is a section of the query editor in the Configuration Tool where the configurator can specify a query using the SQL, a language that database management systems understand. It can be used by SQL experts for queries that are too complex to be defined in the simple form and, for some reasons, cannot be specified using the rule form. For example, a query in the SQL form that finds all members over 16 years old and lists them in the alphabetical order may look like this:

SELECT 
   Member.* 
 FROM 
   Library_Member AS Member 
 WHERE 
   (Member.Age > 16) ORDER BY Member.LastName

This particular example can also be specified using the simple form.

  • Last modified: 2023/05/09 02:09