Activity overview
Latest activity by AndrewMurphy
Spam from Kate??? / comments
Spam from Kate???
Downloaded that & that's working for me now. Slight issue still with how the word LEFT is interpreted. SQLPrompt assumes I mean the function LEFT, whereas in the context of the code I'm writing I can only mean LEFT JOIN at the last character below. I'm not being given when I press space to select/autofill JOIN as I type.
SELECT * from table1
LEFT / comments
Downloaded that & that's working for me now. Slight issue still with how the word LEFT is interpreted. SQLPrompt assumes I mean the function LEFT, whereas in the context of the code I'm writing I...
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 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.
I've never attended any conferences! [image] / comments
I've never attended any conferences!
Licencing
Just to show that sometimes the licensing is read....I don't see any reciprocal offer....nor is there a discount for volume purchases.
"SCHEDULE 3
BEERWARE
The following Beerware is licensed on a ...
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...