Comments
Sort by recent activity
Hi @Beege and @GregDodd,
Thank you for sending us your styles and example code.
We've now been able to reproduce the problem and are currently working on a fix.
We'll let you know as soon as it's available.
Kind regards,
Frederico / comments
Hi @Beege and @GregDodd,
Thank you for sending us your styles and example code.
We've now been able to reproduce the problem and are currently working on a fix.
We'll let you know as soon as it's a...
Hi @GregDodd, @Beege and @jackcrawfish,
Apologies for the issues you are seeing and thank you for reporting the problem.
We've tried to replicate the issue locally but so far we've been unable to.
Would it be possible for you to send us the formatting style (either on the forums or by emailing it to us at sqlpromptteam@red-gate.com) that is throwing up the problem (e.g. Limit LINES)?
Thanks,
Frederico / comments
Hi @GregDodd, @Beege and @jackcrawfish,
Apologies for the issues you are seeing and thank you for reporting the problem.
We've tried to replicate the issue locally but so far we've been unable to.
...
Hi @PeterV,
Unfortunately, at present this behaviour is not supported in SQL Prompt.
I've raised an internal feature request (reference: SP-6460), so hopefully we can look at implementing this at some point in the future.
We will let you know as soon as we have more information.
Kind regards,
Frederico / comments
Hi @PeterV,
Unfortunately, at present this behaviour is not supported in SQL Prompt.
I've raised an internal feature request (reference: SP-6460), so hopefully we can look at implementing this at s...
Hi @Ozzie,
Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6459) to track it.
Best regards,
Frederico / comments
Hi @Ozzie,
Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6459) to track it.
Best regards,
Frederico
Hi @torsten.strauss ,
It's great that it is now working.
You are absolutely right. Some of our default queries need a review to increase their coverage of the formatting options (especially the ones modified/introduced in more recent versions of Prompt).
In the meantime, the easiest way might be to preview your own query instead of using the default when editing your style: [image]
Kind regards,
Frederico / comments
Hi @torsten.strauss ,
It's great that it is now working.
You are absolutely right. Some of our default queries need a review to increase their coverage of the formatting options (especially the one...
Hi @torsten.strauss ,
I may be completely misunderstanding, but wouldn't Expressions > Operators > Alignment > To first list item (instead of the default To statement) work in this case?
With the above example you would get: BEGIN TRY
-- Generate divide-by-zero error.
SELECT 1 / 0;
END TRY
BEGIN CATCH
IF @TRANCOUNT > 0
AND XACT_STATE() <> 0
BEGIN
ROLLBACK TRAN;
END;
THROW;
END CATCH;
If this isn't what you want, can you please format the above code as you would like to see it?
Thanks,
Frederico / comments
Hi @torsten.strauss ,
I may be completely misunderstanding, but wouldn't Expressions > Operators > Alignment > To first list item (instead of the default To statement) work in this case?
With the a...
Hi @torsten.strauss,
Thanks for letting us know about this.
I tried to replicate the issue and taking the Default style as the base with the following modifications:
Statements > Control Flow > Indent BEGIN END keywords
Expressions > Operators > Place on new Line (Never or If longer than wrap column)
We get: BEGIN TRY
-- Generate divide-by-zero error.
SELECT 1 / 0;
END TRY
BEGIN CATCH
IF @TRANCOUNT > 0 AND XACT_STATE() <> 0
BEGIN
ROLLBACK TRAN;
END;
THROW;
END CATCH;
Is this the behaviour you desire?
Kind regards,
Frederico / comments
Hi @torsten.strauss,
Thanks for letting us know about this.
I tried to replicate the issue and taking the Default style as the base with the following modifications:
Statements > Control Flow > Ind...
Hi @tlaqua,
Thanks for getting in touch with us. I'm afraid this is currently not possible in SQL Prompt.
Can you please add a request for this feature in our UserVoice forums?
Kind regards,
Frederico / comments
Hi @tlaqua,
Thanks for getting in touch with us. I'm afraid this is currently not possible in SQL Prompt.
Can you please add a request for this feature in our UserVoice forums?
Kind regards,
Frederico
Hi HenrikM,
I'm sorry to hear you are seeing crashes in SSMS. Unfortunately, we haven't been able to replicate this behaviour on our end.
To help us track this down, can you please:
Let us know which versions of SQL Server instances you connect to?
Tell us what other SSMS extensions besides SQL Prompt have you installed in your system?
Enable verbose logging and send us the log file to sqlpromptteam@red-gate.com so we can check whether Prompt is doing anything at the time of the crash? The steps to do so are explained in this page.
Kind regards,
Frederico / comments
Hi HenrikM,
I'm sorry to hear you are seeing crashes in SSMS. Unfortunately, we haven't been able to replicate this behaviour on our end.
To help us track this down, can you please:
Let us know whi...
Hi @henrik_ffc ,
Thank you for reporting this.
We've recreated the problem locally and have generated an internal bug ticket (reference: SP-6449).
Best regards,
Frederico / comments
Hi @henrik_ffc ,
Thank you for reporting this.
We've recreated the problem locally and have generated an internal bug ticket (reference: SP-6449).
Best regards,
Frederico