What are the challenges you face when working across database platforms? Take the survey
Options

Copy as IN Clause - GUID will shown with {}

ChRohrChRohr Posts: 6 New member
edited September 23, 2016 3:49AM in SQL Prompt
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

Comments

  • Options
    Aaron LAaron L Posts: 596 New member
    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.
  • Options
    ChRohrChRohr Posts: 6 New member
    Hi Aaron

    I use the Version 7.3.0.437.

    Thank you.

    Regards,

    Chris
  • Options
    Aaron LAaron L Posts: 596 New member
    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.
  • Options
    ChRohrChRohr Posts: 6 New member
    Thank you for your help, it works.

    Regards,

    Chris
Sign In or Register to comment.