Comments
Sort by recent activity
I get something similiar with the keywork "IN"...brings up INFORMATION_SCHEMA.xxxx
PITA to deal with. [image] / comments
I get something similiar with the keywork "IN"...brings up INFORMATION_SCHEMA.xxxx
PITA to deal with.
select * from mytable
where id in(formation_schema)
IN not an option at all in the dropdown list.
1st option is INFORMATION_SCHEMA, 2nd is INDEX_COL.
pain to have to go back and delete code and replace with desired result.
version 3.5.0.333 / comments
select * from mytable
where id in(formation_schema)
IN not an option at all in the dropdown list.
1st option is INFORMATION_SCHEMA, 2nd is INDEX_COL.
pain to have to go back and delete code and rep...
I've never attended any conferences! [image] / comments
I've never attended any conferences!
Would also be useful if this extended to calling Functions...PITA having to remember the order of parameters being sought! / comments
Would also be useful if this extended to calling Functions...PITA having to remember the order of parameters being sought!
..."That's a very good idea"
I used to be a big fan of "McGyver"....simple inventive solutions to get out of doggie-pooh situations! [image]
Bart....any comment on that PM I sent you re product enhancement...good, bad, off the wall, illegal :?: / comments
..."That's a very good idea"
I used to be a big fan of "McGyver"....simple inventive solutions to get out of doggie-pooh situations!
Bart....any comment on that PM I sent you re product enhancemen...
As a workaround...what about a home-made solution, involving you copying the settings to a safe area on exit, and re-loading same on entry? Via a batch file? / comments
As a workaround...what about a home-made solution, involving you copying the settings to a safe area on exit, and re-loading same on entry? Via a batch file?
Basically the premise of SQLPrompt is that it sits looking over your shoulder WHEN you code within QA - ready to help. Start QA, and start coding. SQL Prompt should kick in (within 3 seconds default wait time)
You see if QA's co-operating with SQLPrompt if SQLPrompt appears in the QA menu bar...as an add-in. / comments
Basically the premise of SQLPrompt is that it sits looking over your shoulder WHEN you code within QA - ready to help. Start QA, and start coding. SQL Prompt should kick in (within 3 seconds defa...
oooops!!!
"v=b"....typo...I was pasting (Ctrl-v) + bolding (Ctrl-b)....must have missed the ctrl key! (twice)
Andrew / comments
oooops!!!
"v=b"....typo...I was pasting (Ctrl-v) + bolding (Ctrl-b)....must have missed the ctrl key! (twice)
Andrew
I've got the functionality (as designed) to work when the ON condition is on a line of it's own after the 2n table...but it doesn't work when the ON condition is on the same line as the 2nd table.
Re CTRL+Left...this just moves the cursor to the before the "a" / comments
I've got the functionality (as designed) to work when the ON condition is on a line of it's own after the 2n table...but it doesn't work when the ON condition is on the same line as the 2nd table.
...
Ctrl+LEFT when A.* is already typed as part of a larger snippet of code works as "put cursor before a"
whereas
Ctrl+LEFT when A. is being typed works as "change selection/dropdown" list".
re the conversion of * into a "list of all columns"...what I get is column 1 on the line starting where the * was and all other columns on their own independant line. For consistency it would be useful to have all columns on their own lines.
I note also that indentation reported earlier that the indentation is 2x the "TabSize setting + 1" ....ie at position 18...whereas I would assumed it would be at the same position as the starting character being replaced ie position 8 (ie the length of "SELECT a") (I'm using QA).
Finally...when converting "a.*" (no join) to the list of all columns, the "a." bit is not prefixed in front on each column...other than column 1 (by residual effect more than anything else)...if this could be fixed (or become an optional setting) this would be an improvement. / comments
Ctrl+LEFT when A.* is already typed as part of a larger snippet of code works as "put cursor before a"
whereas
Ctrl+LEFT when A. is being typed works as "change selection/dropdown" list".
re the co...