dbForge Studio for MS SQL version 7.1.63 (Windows 11)
Steps to Reproduce:
1. New Query
2. Add tables to the Query Builder
3. Give tables alias
4. Join on fields as needed
5. View text tab and qualify fields with alias (manually type them in)
6. Return to Query Builder tab
7. Execute query (all good so far, results show)
8. In Query Builder, check one field from a table (to be included in query results)
9. Execute query
Query fails to execute with error "Ambiguous column name".
Look at Text of generated by query builder and all the alias I entered are REMOVED and I get a red underline on a field that wasn't modified?
Below is the sequence to clearly illustrate the problem:
Step 1 (notice alias are there and intacted)
Step 2 (Query Builder, all looks good)
Step 3 (check one field to add - red square)
Step 4 (Execute the query and I get an error)
Step 5 (Query builder removed all my alias and created the query with ambiguous references Equipment_ID)
This issue has rendered Query Builder useless and has been around for the entire Version 7.x series (it was NOT present in Version 6.x series).
DevArt/dbForge support was terrible, they basically told me to send them a database sample and/or make a video?? This issue NEEDS to be fixed ASAP, the company I work for doesn't pay me to report errors in your product, that's what your QA department is supposed to find and report, not paying customer.
Rob.