Activity overview
Latest activity by brianorrell
Not asking for it to limit to only the tables, just prioritize.
If a database doesn't have foreign key relationships, then it shouldn't affect the listing at all.
But for a database that DOES have foreign key relationships, it would be crazy to think that the JOIN would not be using those tables in a JOIN 99% of the time.
In the same way that you provide options for what shows on JOIN considerations, the same option could be available for the tables displayed on a JOIN. / comments
Not asking for it to limit to only the tables, just prioritize.
If a database doesn't have foreign key relationships, then it shouldn't affect the listing at all.
But for a database that DOES have ...
So, when I type in JOIN, the tables that are shown to me do not take into account the foreign key relationships that are setup on the tables? In other words, there is no difference between the list of tables I see when I type in FROM and when I later type in JOIN?
That was really the biggest selling point in my opinion for SQL Prompt. I could open a database I had little knowledge of and very easily write SQL very quickly.
I demoed this feature to a lot of my clients who were immediately ready to buy because of that specific functionality.
You guys should definitely re-think adding that in. That was the only reason I wanted to buy SQL Prompt (and possibly get it for the rest of my staff). / comments
So, when I type in JOIN, the tables that are shown to me do not take into account the foreign key relationships that are setup on the tables? In other words, there is no difference between the lis...
OK, that makes sense with the columns.
But now, it still isn't recommending a table to join to based on the foreign keys...
If I type in
SELECT *
FROM (Prompts for Table list) [Account]
INNER JOIN (Shows a listing of all tables with [Account] as the first listing-- basically, it is just showing the same list it showed when I typed in FROM with no regard to the tables that have foreign key relationships to the Account table)
Is this the normal intellisense? It use to show the tables that had foreign key relationships only. / comments
OK, that makes sense with the columns.
But now, it still isn't recommending a table to join to based on the foreign keys...
If I type in
SELECT *
FROM (Prompts for Table list) [Account]
INNER JOIN ...
If I type in
SELECT
FROM (It prompts me with a list of tables) [Authors]
INNER JOIN (It then prompts me with a list of fields!-- not right, it should prompt me with a list of tables that have foreign key relationships to Authors)
It doesn't matter which database I select, the intellisense is always acting the same. I tried installing the 3.1 release candidate but that didn't improve anything. / comments
If I type in
SELECT
FROM (It prompts me with a list of tables) [Authors]
INNER JOIN (It then prompts me with a list of fields!-- not right, it should prompt me with a list of tables that have forei...
JOIN Completion Is Not Right
I have been trying to use SQL Prompt 3 and am running into a lot of problems with the JOIN Auto-Completion.
When I type INNER JOIN it pops up a list of FIELDS having nothing to do with any of the f...