Editing queries in column Mode for SQL Assistant v15

Tools

Editing queries in column Mode for SQL Assistant v15

Hi,

My company recently upgraded our SQL Assistant verson from version 13.XX to version 15.  First let me say that I'm enjoying a lot fo the functionality that is new to this version.  However, one of the features that I sorely miss is the ability to edit a query in column mode.  For example, I was able to modify SQL query by holding down ALT-SHIFT and arrow keys.  This would highlight a BLOCK of text in multiple rows for one or more columns without wrapping to the end of the line. THe cursor would then blink in every line at once. Then I could type as normal and all chagnes would be made to every line at once in the same column. Great for adding commas or aggregate functions to multiple fields. 

With the new version, if I press ALT-SHIFT-DOWN it will highlight from the cursor starting location and wrap the seleciton to the next row just below the cursor.  If I type then the entire highlighted area gets changed instead of just the column the cursor was in.

If I press ALT-SHIFT-Right/Left and then up/down it will highlight as I expected it to, however it will only make changes to the first row and the selection goes away.

I'm hoping that there is a way to enable this functionality or that I can juse a different key sequence.  Does anyone know how?

Thank you,

Calvin

Tags (1)
4 REPLIES
Senior Apprentice

Re: Editing queries in column Mode for SQL Assistant v15

Hi Calvin, there was a bug in the initial version of SQLA 15 which has been fixed in the very first patch 15.0.0.1.

Upgrade to get the latest patch level.

Re: Editing queries in column Mode for SQL Assistant v15

Hi Dieter,

I am looking for the patch 15.0.0.1, can you please help me to find this? I can find only "15.0.0.0".

Thanks.

Darshan

Senior Apprentice

Re: Editing queries in column Mode for SQL Assistant v15

Hi Darshan,

you must be a custumer to get access to Teradata's patch server (if you are simply ask your DBA).

Hopefully there will be a 15.10 TTU soon.

Re: Editing queries in column Mode for SQL Assistant v15

Yes Dieter, we are Teradata customer. Let me contact them for the patch.

Thanks.