How can we help you today? How can we help you today?

Problem with qualifiers on joins

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
IanC
0

Comments

4 comments

Sort by
  • David Priddle
    Hi Ian,

    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 david.priddle@red-gate.com we'll take a look at it and see what's going wrong.

    Best regards,

    David
    David Priddle
    0
  • David Priddle
    Hi Ian,

    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
    David Priddle
    0
  • IanC
    Hi David,

    Have tried the latest update - all seems good :) Thanks very much for the prompt fix.

    Cheers,
    Ian
    IanC
    0
  • David Priddle
    Hi Ian,

    Glad it works for you! Let us know if you have any questions.

    Best regards,

    David
    David Priddle
    0

Add comment

Please sign in to leave a comment.