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

SQL Prompt version 8.0.0.1241 is moving comments between commas

When I format this statement with sql prompt
SELECT * FROM sys.objects WHERE OBJECT_ID IN (/*1=*/ 0, /*2=*/ 0, /*3=*/ 0, /*4=*/ 0, /*5=*/ 0, /*6=*/ 0)

it formats to below, it moves comments around commas which should not happen
SELECT * FROM [sys].[objects] WHERE [object_id] IN (/*1=*/ 0 /*2=*/, 0 /*3=*/, 0 /*4=*/, 0 /*5=*/, 0 /*6=*/, 0)
Tagged:

Comments

  • Options
    James RJames R Posts: 104 Silver 4
    Hi gvarol,

    Thanks for your post!
    I've managed to reproduce this issue here, it seems to be a bug with the "Place commas before items" option. I'll update you when we have a fix :)

    Thanks!
    Software Engineer
    Redgate Software
Sign In or Register to comment.