After an SQL Database Method has been created, it should be tested to make sure that the query template is correct and to generate information needed to generate search interfaces. () To test an SQL Database Method , select its icon in the contents view of the containing Folder . Selecting the Test tab causes an input form to be displayed, as shown in figure . Selecting the " Submit Query " button causes the database method to be executed and the results to be displayed in a table (figure ). The SQL used is also shown. If the results are not what was expected, the SQL may be inspected to see if the expected substitutions were performed.
If an error occurs, an error message is displayed as shown in figure See Test output showing an error message and SQL used..