Devart Forums

The latest version of SQLComplete Express (free version) is now ignoring the case of database field names. When I select one from the suggestion list, it is inserted as all lower-case letters.

I noticed this as well, and looked up these forums just to submit the same request.

I am also using the free version, and before I updated it (not sure what version I had before), the suggestions always matched the case of the actual database / table / column.

Now, on version 4.0.53, it appears to be using the Identifier Case from the formatting profile.

I would like to suggest that you add an option under Identifier Case in the formatting profile to match the existing names, similar to the "Do not change" option you have under Variable Case.

The new option 'Do not change' will be added in the next build of dbForge SQL Complete.

Currently, we suggest you to install the Trial version of the Standard Edition of dbForge SQL Complete, but not the Express one, and make the following changes:

1. Select 'SQL Complete -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select a profile.
4. Click 'Edit Profile...'. The 'Edit Profile' window opens.
5. Select the 'Text Case -> Identifier Case' branch.
6. Select the 'As in the database' radio-button.

Now fixed in 4.0.54

Thank you Alexa

Alexa,

Thank you for the free edition of SQL Complete. I use it daily and very much appreciate your prompt fix to the identifier casing issue. I look forward to investing in the paid edition soon.

Regards,
Bob

Please let us know if other questions arise.