Control supports a type of report referred to as a SQL Report. In its simplest form, this is nothing but a SQL statement that can be put in the menus. There are two primary uses for SQL Reports:

  • Retrieve Data into a File
  • Update Data in the Database
  • Test SQL code for application in a macro

**A SQL Report allows direct access to SQL commands that can be used to modify the database. Using an update SQL query if you are not familiar with SQL and the database structure in Control could result in contamination, even loss, of your data.**

You could leave a comment if you were logged in.