Posts
Sort by recent activity
Big red X displayed after sync
I am running Data Compare 8.1.04 Pro on a XP 32 bit box. After I did a compare and sync and close the Success box, Data Compare displayed a large red X with the menus and icons above it.
To get bac...
Sort order on inserted columns
When doing a tab after a * or having inserts completed the sort order of the column names is now alpha. In earlier versions prompt would insert the column in actual table order. Alpha makes the fun...
SQL 2008 and Prompt?
With SQL 2008 now offering intellisense are there plans to have Prompt work with that product and provide support for snippets?
Tim
Denver, CO
Prompt 3 over aggressive and slows my coding
Another complaint. I am in a comment block trying to comment my code. I enter the word "to" and it is forced to upper case. So now I not only have a candidate list that I am forever having to hit e...
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...