Activity overview
Latest activity by johnw
Yes it is checked / comments
Yes it is checked
From the "SQL Prompt" menu at the top of your editor click "Cache Management" / comments
From the "SQL Prompt" menu at the top of your editor click "Cache Management"
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...
Oh and notice the line
INNER JOIN tblPagePanel PP ON (P.nPageID = PP.nPageID)nPageID)
the "nPageID)" was added by SQLPrompt because the candidate list opened when I typed the closing parentheses. I then hit the Enter key to go to the next line and SQLPrompt inserted the first item in the now open candidate list which was "nPageID". / comments
Oh and notice the line
INNER JOIN tblPagePanel PP ON (P.nPageID = PP.nPageID)nPageID)
the "nPageID)" was added by SQLPrompt because the candidate list opened when I typed the closing parentheses. I...
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...
Another one.
I now have the auto complete parentheses turned off so I type
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON (
and the correct join options appear, however when I select my join from the candidate list and add the closing parentheses manually the candidate list reappears with a list of columns from tblTime not allowing me to hit "Enter" to go to the next line without first hiting the "Esc" key to close the candidate list. / comments
Another one.
I now have the auto complete parentheses turned off so I type
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON (
and the correct join options appear, however when I select my join fr...
Here is the problem... Everything works the way I would expect it to "IF" I do not use an opening parentheses. So in the example
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON
The first item in the candidate list is R.nRequestID = T.nRequestID
However if I use an opening parentheses AND have the option to automatically close parentheses (SQL Prompt > Auto Insert > Automatic Closing Characters), all of this functionality is out the door. I did notice that by default Parentheses was not checked in this section. Is this a known issue? / comments
Here is the problem... Everything works the way I would expect it to "IF" I do not use an opening parentheses. So in the example
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON
The first item in...
When typing:
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON (R.nRequestID = T.
I would think that I would only get items in the candidate list that matched either by foriegn keys or at the least by datatype. I know its possible to join on two different datatypes but it is not best practices. / comments
When typing:
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON (R.nRequestID = T.
I would think that I would only get items in the candidate list that matched either by foriegn keys or at the leas...
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...