Comments
Sort by recent activity
Hi,
Thanks for the feedback. We'll try and incorporate it into a future version.
Regards,
Tilman / comments
Hi,
Thanks for the feedback. We'll try and incorporate it into a future version.
Regards,
Tilman
Hi,
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 begin with the letter "n". But instead of only getting the columns that start with the letter "n" that are the in tblPagePagel table (note the PP alias) I get ALL the columns that start with the letter "n" between all three tables used in this query even though I am using the PP alias for tblPagePanel.
Have you enabled 'Show objects for specified owner or schema' on the Options dialog and refreshed the cached database?
Regards,
Tilman / comments
Hi,
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...
Silly me... Actually that option has nothing to do with qualifying by a table, it just affects schemas and users. Qualifying by tables should work always.
I can reproduce your problem when I have the 'nPageID)' bit, i.e. when it's invalid SQL. When I remove that it bit it works fine for me.
Tilman / comments
Silly me... Actually that option has nothing to do with qualifying by a table, it just affects schemas and users. Qualifying by tables should work always.
I can reproduce your problem when I have t...
Hi,
can the download of a database definition be interrupted
I'm afraid this isn't currently possible, but you're not the first to ask and it's on our list.
i connected to a database with many many objects over a slowish VPN connection, and it decided to download the objects.
You can 'blacklist' databases and servers that you don't want to be cached via the Options dialog. Also, when a database is cached for the first time its schema is written to a local file and retrieved from there subsequently.
Regards,
Tilman / comments
Hi,
can the download of a database definition be interrupted
I'm afraid this isn't currently possible, but you're not the first to ask and it's on our list.
i connected to a database with many ...
Hi
I also posted this same suggestion on this thread.
Please see my response to that thread.
Tilman / comments
Hi
I also posted this same suggestion on this thread.
Please see my response to that thread.
Tilman
Hi,
Thanks for the feedback. The more valid your SQL is, the better SQL Prompt should work. So if you don't want to specify your columns at the start, I suggest putting a wildcard ('*') there.
E.g.
SELECT *
FROM dbo.CONTRACT ORD (NOLOCK)
INNER JOIN dbo.CONTRACTITEM ITM (NOLOCK)
ON ( ORD.CONTRACTNO = ITM.CONTRACTNO )
INNER JOIN dbo.Master MI (NOLOCK)
ON (ITM.masterno = MI.masterno )
WHERE DATEDIFF(DAY, ORD.)
You can then also replace that wildcard with the explicit column list, by placing the caret behind it and pressing Tab.
Regards,
Tilman / comments
Hi,
Thanks for the feedback. The more valid your SQL is, the better SQL Prompt should work. So if you don't want to specify your columns at the start, I suggest putting a wildcard ('*') there.
E.g....
Yes, I would suggest at least putting a '*' there, don't leave it empty. The more valid your SQL is, the better Prompt will work.
Tilman / comments
Yes, I would suggest at least putting a '*' there, don't leave it empty. The more valid your SQL is, the better Prompt will work.
Tilman
Hi,
have you tried switching off '.' as a completion key? You can do this on the Candidates tab of the Options dialog.
Regards,
Tilman / comments
Hi,
have you tried switching off '.' as a completion key? You can do this on the Candidates tab of the Options dialog.
Regards,
Tilman
Hi,
PostPosted: Thu Dec 14, 2006 5:10 pm Post subject: Re: tgoldstein@co.arapahoe wrote:
All in all I think this functionality has gone from almost right to more work than it is worth.
I'm trying to stick with it but it does seem to hinder me more at times then help.
Other people have also mentioned this and I have added it to our list to bring back the v2 functionality. However, I don't think it will happen vor v3.0, though.
Hitting comma at the end of a field causes a candidate list to appear. Probably a good thing since it is expecting you to select the next field. Instead, I want to hit enter to put the field on a new line. So I get the first item in the candidate list instead.
We will make the Enter key configurable in the final release, so you can turn it off as a completion key. For now, you could turn up auto-pop up all thogether. Otherwise, Esc is your friend [image] If you expand the wildcard character '*' or use the column picker you can specify to insert each column on a new line.
Arrowing up and down in a 1300+ line stored procedure is a lot slower. Paging up and down has no performance hit.
We are aware of the issue and hope to improve it for the final release.
Copying a section of code (regardless of size) causes a 3-5 second pause.
I'm afraid I can't reproduce this. Could you tell me what editor you are using?
Regards,
Tilman / comments
Hi,
PostPosted: Thu Dec 14, 2006 5:10 pm Post subject: Re:tgoldstein@co.arapahoe wrote:
All in all I think this functionality has gone from almost right to more work than it is worth.
I'm tryin...
Hi James,
This is odder than you think, because the schema panel is not supposed to pop up in this situation. Could you tell me what it contains? Also, what version of MS are you using. Did you have the previous beta installed, and if so, did you uninstall it before you installed this version? Finally, what OS and language settings do you have?
Regards,
Tilman / comments
Hi James,
This is odder than you think, because the schema panel is not supposed to pop up in this situation. Could you tell me what it contains? Also, what version of MS are you using. Did you hav...