Copy as IN Clause - GUID will shown with {}

ChRohr

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

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.

ChRohr

Hi Aaron

I use the Version 7.3.0.437.

Thank you.

Regards,

Chris

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.

ChRohr

Thank you for your help, it works.

Regards,

Chris