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

Copy as IN Clause - GUID will shown with {}

If I copied some rows with Copy as IN Clause and they paste, it will be past like this:

IN ({9c2e5dc3-1210-4a22-b2fe-54eaa0d15005},
{9b02eb62-96d9-4714-b6ca-e94cc264966a})

Please could you solve this issue.

Thank you.

Regards

Chris
ChRohr
0

Comments

4 comments

Sort by
  • Aaron L
    Hi Chris,

    Could I check which version of SQL Prompt you're using? (listed under SQL Prompt->Help->About SQL Prompt)

    I just tried it here on and the guids should be copied as strings, eg: 
    IN
(
'{9c2e5dc3-1210-4a22-b2fe-54eaa0d15005}',
'{9b02eb62-96d9-4714-b6ca-e94cc264966a}'
)

    Thanks,
    Aaron.
    Aaron L
    0
  • ChRohr
    Hi Aaron

    I use the Version 7.3.0.437.

    Thank you.

    Regards,

    Chris
    ChRohr
    0
  • Aaron L
    Hi Chris,

    This appears to be working for me in 7.3.0.437 too, but it might be worth you trying to upgrade to the latest build just to make sure.

    Would it be possible to provide a small sample script of where you're seeing this break and paste exactly what's copied to your clipboard here?

    Thanks,
    Aaron.
    Aaron L
    0
  • ChRohr
    Thank you for your help, it works.

    Regards,

    Chris
    ChRohr
    0

Add comment

Please sign in to leave a comment.