Activity overview
Latest activity by Maurice
Synonym not always resolving
Hi,In SQL-Prompt 10 (10.0.1.12389) when using a synonym the fields or the name of the synonym are not always resolved when there is no alias.Kind regards,Maurice
[image] Just received a mail that I was one of the lucky winners !
Looking forward to those Red Gate prices / comments
Just received a mail that I was one of the lucky winners !
Looking forward to those Red Gate prices
Hi Ali,
It look like its a cache thing, it was indeed a new view.
I refreshed the suggestions, but it was not directly refreshed, after closing the query that has made the view and a refresh of the suggestions the fields popped up.
Maybe it's something to look into, that the refresh not always really refreshes.
For now my problem is fixed, thanks for your time and support.
Maurice / comments
Hi Ali,
It look like its a cache thing, it was indeed a new view.
I refreshed the suggestions, but it was not directly refreshed, after closing the query that has made the view and a refresh of the...
Hi Ali,
That option is enabled on my machine. [image]
And as I mentioned before, not all synonyms have this behavior, most of them work just fine.
If I use the base view that is used for the synonym in the other database, the fields are present if I expand the wildcard. (select * from ViewUsedForSynonym)
Maurice / comments
Hi Ali,
That option is enabled on my machine.
And as I mentioned before, not all synonyms have this behavior, most of them work just fine.
If I use the base view that is used for the synonym in the...
Synonyms wildcard not expanding
Hi,
I am using SQL Prompt 7.2.3.283 in management studio 2014 and I have the following issue.
Sometimes when using as select * from synonym (witch is based on a view in the other database) the wild...
Hello Aaron,
Fix works fine!
Thanks for the quick fix.
Maurice / comments
Hello Aaron,
Fix works fine!
Thanks for the quick fix.
Maurice
Wild card not expanding synonym in 7.1.0.300
Hello,
In SQL Promt 7.1.0.300 is a synonym not expanding when the synonym name is in front of the wild card
SELECT [synonym].* FROM [dbo].[synonym]
Without the synonym the wild card is expanding j...
Hi Aaron,
Installed the new build and it's fixed!.
Thanks,
Maurice / comments
Hi Aaron,
Installed the new build and it's fixed!.
Thanks,
Maurice
Hi Aaron,
Great, I will check it in the next Beta.
Just want to say that you all do a great job with beta en new functions! My job is so much easier with SQL-Prompt [image]
Maurice / comments
Hi Aaron,
Great, I will check it in the next Beta.
Just want to say that you all do a great job with beta en new functions! My job is so much easier with SQL-Prompt
Maurice
Prompt shows wrong fieldnames with EXCEPT or INTERSECT
When expanding a wildcard in a EXCEPT or INTERSECT query it shows the fields from the first SQL statement when you expect the field from the second statement.
SQLPrompt version 7.1.0.118CREATE TABL...