Activity overview
Latest activity by TheRightAmount
Looks good so far! Thanks very much for the speedy turnaround. / comments
Looks good so far! Thanks very much for the speedy turnaround.
That's great, thanks. / comments
That's great, thanks.
Hi, yes I updated to the latest release just after my last post. The problem still occurs. Style file attached - I've renamed to .txt because it wouldn't allow me to add it with its original name. / comments
Hi, yes I updated to the latest release just after my last post. The problem still occurs. Style file attached - I've renamed to .txt because it wouldn't allow me to add it with its original name.
Hi Fabiola
I'm on version 8.0.11.2296.
I've just tried the table definition you posted and realised why you might not be seeing my issue. In the Whitespace section I have Tab behaviour set to "Only tabs", and Number of spaces in tabs set to 4. When I reformat the code you've posted above it pushes all of the datatypes to the right by one character, to the next tab stop. (If I switch to "Only spaces" it puts it back the way you have it formatted.)
If I stick with "Only tabs" and delete the last two characters from your long column name, my problem appears, as you can see in the image below. So it appears to happen when the end of that long column name aligns with a tab stop.
Cheers
Matt [image] / comments
Hi Fabiola
I'm on version 8.0.11.2296.
I've just tried the table definition you posted and realised why you might not be seeing my issue. In the Whitespace section I have Tab behaviour set to "Onl...
This is maybe a better example. Those are spaces rather than tabs after the AddressLine columns. There are tabs after all the other column names. To sort out the formatting I have to delete those spaces, replace them with tabs, and add an extra tab in front of all the other datatypes. If those AddressLine columns had had shorter datatypes I'd also have had to fix the tabs before the NULLs as well. [image] / comments
This is maybe a better example. Those are spaces rather than tabs after the AddressLine columns. There are tabs after all the other column names. To sort out the formatting I have to delete thos...
Alignment incorrect in CREATE TABLE statement
I've set up a formatting style in which I've asked for data types and constraints to be aligned in my DML statements. However, I'm finding that SQL Prompt doesn't always get this right. It seems ...