Posts
Sort by recent activity
Hyper Active Candidate Pop-up
Have been trying to use Prompt 3 since its beta release earlier this week. Used Prompt 2 for months and liked it so much I bought the 3 license site already. What I am finding with 3 is that the po...
Auto insert for "SELECT COUNT(*) FROM"
How can I put in an auto insert for "SELECT COUNT(*) FROM". When I enter this in as my snippet it returns "SELECT COUNT* FROM" in the test box. Is there an escape character for the parenthesis?
Wil...
Incorrect formatting with BETWEEN and COALESCE
Here is a snippet where the formatting is not working 100%. The first COALESCE is formatting as I expect and want. But the second COALESCE that is creating the ending parameter for the BETWEEN is n...
Prompt 2 does not work withing comment marks?
My normal habit when I am writing complex queries is to put a comment block with /* */ at the bottom and small queries that I need to peek at tables and values within the comments and then run them...
Terrible performance in large scripts
When I am working on a large script (100 plus lines) and am tabbing in to format code everything stalls out. To get in 5 tabs takes about 45 seconds. Almost to the point that I have to turn Prompt ...
Encapsulate as proc and parameters, comments
Any pointers on using the Encapsulate function with parameters. I have been playing with it some to try and get a feel if it is useful to me. I am unable to determine how to write my queries that i...
Auto insert pegging processor
I tried to add the following as an auto insert
/*
CREATE DATE:
CREATED BY: Tim Goldstein
**********************************************************************************************
FUNCTION:
**...
Any update on the release date of Prompt 3?
With the close of the extended special offer drawing near, I am wondering if there is an update on the release date for Prompt 3.0. Seems to be little talk about it since the end of August.
Tim
Den...
Upper Case keywords
When I run upper case keywords on a simple select with a case statement in the select list I get the following:
SELECT CASE WHEN a = b then 'a'
ELSE 'b'
end AS test
FROM actlink
The keywords TH...
Auto Insert ssf != SSF
Auto insert if I type ssf works great. But if I type it upper case as SSF it does not work. I have tried going into Options and adding an Auto insert for SSF, but in the options ssf = SSF and it wi...