Project Set Up Instructions
-
Each Project you start needs to be stored as a Project in the embedded database which is recording a project name, a DB connection and preferences. Creating and editing, loading Projects is done through the Project Menu at the top of the form.
-
Most of the information required by the Project Form is simple just fill in.
-
For the database connection string you can paste a string into the form or use the connection builder. You will need to have a login with permission to access Schema, meta data. When you Test the Connection after entering or building the connection string fix-SQL Editor will try to determine if you have appropriate permissions to access all meta data. If an issue is detected your set up will be valid however processing may not work until you configure the correct permissions. If your not sure how to do this follow this link.Grant View Definition
-
In the Exclusions list page you need to add any recurring non sql words which are to be ignored in processing. An example of this would be a connection string variable used in the signature of a Method that is used by a helper class. You may have seen the old Microsoft .net SqlHelper class which is a good example of this. The placement of these types of variables is unpredictable so we need to explicitly tag them as words to be ingored by processing otherwise they could be interpreted as variables in some situations. The most recent fix-SQL Editor is quite reliable at doing this for you however if you see isssues with a variable manually exclusion will fix the issue.
-
-
When you've completed and saved the Form you are ready to work with the project. You can edit any value at all in the Project file by selecting Project Menu and Edit Project. You can also load an existing project with Load Project Menu.
Security
You need to have Sql Server VIEW DEFINITION permissions at the database or object level to access the database Schema.
-
Queries can be run for testing within fix-SQL Editor.
-
The next release in August 2020 is a free update and will include comprehensive processing for writing Stored Procedures and converting dynamic SQL to Stored Procedures.
-
Support for User Defined Types are used in parameters when they are registered in the database and all related schema detail is automatically detected.
-
Table joins are automatically listed for Auto Complete selection and take account of any aliases used in the query. You see them when you type or complete the keyword JOIN. These joins will take account of all existing joins in the query to maintain the integrity of the query and newly referenced tables through the join are added to Auto Complete. You can edit an alias and it will be refactored within the query. You can also define an alias for a table you are going to create a join to in the Tables and Aliases treeview and it will be used in joins.
Register fix-SQL Editor
Registration of fix-SQL Editor is simple. Go to the Project Menu and select 'Buy fix-SQL Editor' or use the link on the web site. Complete your payment through the secure portal. You will receive an email in a few minutes with an ActivationID number. Select 'Enter Activation ID' from the Help Menu. Enter the ID into the box and fix-SQL Editor will be registered. The license you purchase does not expire however it is bound to the PC it was installed onto.