Format SQL Fails with CURSOR declaration

MikeyC

Using SQL Prompt 4.0.4.11 when I format this code:

DECLARE crsScheduledTickets CURSOR FOR
	SELECT
		backup_set_id,first_family_number,first_media_number,filegroup_name,page_size,file_number,backed_up_page_count,file_type
	FROM
		msdb.dbo.backupfile
	ORDER BY
		backup_set_id;

I get this:

DECLARE crsScheduledTickets CURSOR FOR
SELECT
backup_set_id,first_family_number,first_media_number,filegroup_name,page_size,file_number,backed_up_page_count,file_type
FROM
msdb.dbo.backupfile
ORDER BY
backup_set_id ;

When I should get this:

DECLARE crsScheduledTickets CURSOR FOR
 SELECT
  backup_set_id,
  first_family_number,
  first_media_number,
  filegroup_name,
  page_size,
  file_number,
  backed_up_page_count,
  file_type
 FROM
  msdb.dbo.backupfile
 ORDER BY
  backup_set_id ;

This appears to be related to SP-2773 which was fixed, so whatever was done to fix the other things needs done to fix this too.

Anu D

Many thanks for your post and apologies for the inconvenience caused.

I have already logged this issue in our internal tracking system and added your comments to it.

Tracking Id for this issue is SP-2913 our developers will look into this and fix it in future release.

I will update you as soon as it is fixed.

Anu D

Hope I would have waited couple of hours to reply your post

I am pleased to inform you that we have fixed the SQL Prompt issue (SP-2913) you were experiencing in our latest patch.

Kindly check the forum post to download the version: https://www.red-gate.com/messageboard/v ... hp?t=10248

Please let us know if this fixes your issue.

MikeyC

Yes, it does appear to have fixed the problem. I think that is the best turn-around I have seen on a bug fix so far. Thanks!

Is this issue really the only other issue fixed in 4.0.4.14? (Everything else that is listed was fixed in 4.0.4.11.)

Anu D

Yes that is correct that's the only bug fixed in 4.0.4.14 it being a cumulative patch I need to include the whole list in it.

That's great that it fixed the issue for you!

Kindly let us know if you have any issues or questions regarding the product,I'll like to help.