Posts
Sort by recent activity
Adding new objects to database cache
hehe Another one...
If you create a new object in sql such as
create view vw_testing
as
select * from table
the new object (view) is not added to SQL Prompts cache and I have to refresh the cache m...
Auto Closing Characters
Problems with Auto Closing Characters:
When I type
SELECT '
SQL Prompt changes the code to
SELECT ''
which is correct because I have apostrophe as an auto closing character.
However if I type
SELEC...
Filtered Columns in Candidate List When Alias Used
If I type the following query:
SELECT *
FROM tblPage P
INNER JOIN tblPagePanel PP ON (P.nPageID = PP.nPageID)nPageID)
INNER JOIN tblPanel PNL ON (PP.n
I get the candidate list with the columns that...
Auto Completing joins
I thought I saw some functionality in version 2 that looked like it wanted to give a candidate list of potention columns to join on when the user started a join syntax. For example typing in:
SELEC...
New/Open query freezing
When you create a new query or open an existing query, SQLPrompt pops up and then locks down my editor until it gathers database information (refreshes). This is a huge annoyance because I am tryin...