Checking Syntax on a created Query
Home > (Select - Application Name) > Manage Reports > Ad Hoc Queries > Select any Report from the dropdown list > Click on Check Syntax
While in the Ad Hoc Query, you can check Syntax by clicking on the Check Syntax button.
- This will do a syntax check and show you the results. It will check for any syntax errors in your file and supply you will an error message: i.e.: Error in executing query...!!! Invalid object name “tbUserss”.
- If no errors you will get a message: Query Executed Successfully with # of Records.
- If you have written a query, select the Save button to name your report and save the query.
- The following screen will appear, enter the name and click Save.
- Delete Saved Query will remove the Query from the system completely.
