Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.
Problem with qualifiers on joins
IanC
Posts: 6 New member
I'm experiencing the following issue with SQL Prompt failing to insert object qualifiers on joins - it was happening in v6 & is continuing to happen in 7:
The auto-complete drop-down for a join will show the suggested join conditions with qualifiers - e.g. 'A.Field1 = B.Field1'. However selecting the suggestion will copy it in to the query window without the qualifiers - e.g. 'Field1 = Field1'. Undoing then repeating the operation will result in the qualifiers being successfully copied, as will typing part of the qualifier before selecting the auto-complete.
Any ideas what's going on or if a fix can be issued?
Thanks,
Ian
The auto-complete drop-down for a join will show the suggested join conditions with qualifiers - e.g. 'A.Field1 = B.Field1'. However selecting the suggestion will copy it in to the query window without the qualifiers - e.g. 'Field1 = Field1'. Undoing then repeating the operation will result in the qualifiers being successfully copied, as will typing part of the qualifier before selecting the auto-complete.
Any ideas what's going on or if a fix can be issued?
Thanks,
Ian
Comments
We're having some trouble reproducing it currently so getting your options would help us out a lot.
Could you go into the SQL Prompt Options window and click the Export... button. If you send the file over to me at [email protected] we'll take a look at it and see what's going wrong.
Best regards,
David
We've got a new private build for you to try with a fix for the issue you found with joins - could you try it out and let me know how it goes?
Best regards,
David
Have tried the latest update - all seems good
Cheers,
Ian
Glad it works for you! Let us know if you have any questions.
Best regards,
David