Resetting Options to the Original Set
BSovers
Posts: 3
Sorry for the lame question, but is there a way to reset the Refactor formatting to the original options?
:oops: I've already figured out how to screw them up and save the screwed up option settings!
:oops: I've already figured out how to screw them up and save the screwed up option settings!
Comments
The options sets are saved in your profile, for instance
C:\Documents and Settings\Owner\Application Data\Red Gate\SQL Refactor\Options
On a clean installation, there are no files in the directory, so I'd assume that moving any files out of there would put the program back to 'factory' settings.
FROM OPENXML(@i, 'DocumentElement/NEWPOST',2)
WITH ( ID VARCHAR(36), SITEURL NVARCHAR(400), PERMALINK NVARCHAR(400), POSTEDDT NVARCHAR(50), AUTHORNAME NVARCHAR(200), AUTHORLINK NVARCHAR(240), FOUNDDT NVARCHAR(50) )
all came out on 2 lines
Also, there does not seem to be any options which break the WITH... statement into multiple lines.
Regarding the OPENXML issue you're having: Refactor doesn't presently consider this as a candidate for wrapping - actually, it will treat the whole clause as a candidate but not the individual parts of the WITH clause. This behaviour usually produces good results for table elements, but this is a case where it obviously doesn't. I've added this as a bug to our issue tracking system.
Software Developer
Red Gate Software Ltd.