Comments
Sort by recent activity
Hello,
User-defined aliases are case sensitive, i.e. if you table name is recorded as Name in the database, then typing name in the user-defined alias will not get the user defined alias to work for that table 'Name' in your queries.
And yep, alias assignment works only on using auto-completion. I presume it was part of the design but I should admit that I am not entirely sure on that end!
Thanks,
Tanya / comments
Hello,
User-defined aliases are case sensitive, i.e. if you table name is recorded as Name in the database, then typing name in the user-defined alias will not get the user defined alias to work fo...
Fair enough and your request is logged in our database for review.
Thanks,
Tanya
Project Manager
Red Gate Software Ltd / comments
Fair enough and your request is logged in our database for review.
Thanks,
Tanya
Project Manager
Red Gate Software Ltd
Hi,
Hmmm...but SQL Prompt should be able to suggest the object by the time you key in the first part, i.e. really in the candidate list(the suggestions window that gets populated by SQL Prompt) and choosing that would save you from even typing the entire string. Is there any particular reason that you'd rather prefer it the way you just suggested?
Thanks,
Tanya / comments
Hi,
Hmmm...but SQL Prompt should be able to suggest the object by the time you key in the first part, i.e. really in the candidate list(the suggestions window that gets populated by SQL Prompt) and...
Hi,
Pressing tab expands the columns in the table and at this point of time it is SQL Prompt's code completion functionality that is at work.
For your layout settings to take effect, you need to click on Layout option in the SQL Prompt menu and that would format your code as you have customised in your settings.
I hope that helps.
Thanks,
Tanya / comments
Hi,
Pressing tab expands the columns in the table and at this point of time it is SQL Prompt's code completion functionality that is at work.
For your layout settings to take effect, you need to cl...
Hi,
Are you trying to use alias or does it fail when you try to qualify the column names using table names?
Can you give me an example of a query that causes this issue so that it helps me understand the issue?
Many thanks,
Tanya / comments
Hi,
Are you trying to use alias or does it fail when you try to qualify the column names using table names?
Can you give me an example of a query that causes this issue so that it helps me understa...
Hi,
Apologies for the trouble you are facing.
Please contact support@red-gate.com for the fix to this issue.
Thanks,
Tanya / comments
Hi,
Apologies for the trouble you are facing.
Please contact support@red-gate.com for the fix to this issue.
Thanks,
Tanya
Hello,
I am glad you like the layout functionality.
The feature suggested in this posting is logged into our database and we will review it for our future versions:)
Thanks,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hello,
I am glad you like the layout functionality.
The feature suggested in this posting is logged into our database and we will review it for our future versions:)
Thanks,
Tanya
Project Manager
R...
Hi Paul,
If you are asking for SQL Prompt to insert tabs instead of spaces while laying out, I am sorry we do not have that option:(
Thanks,
Tanya / comments
Hi Paul,
If you are asking for SQL Prompt to insert tabs instead of spaces while laying out, I am sorry we do not have that option:(
Thanks,
Tanya
Hi,
Does it happen consistently for a particular script?
If so, would it be possible for you to give us the script that is causing the exception as it would help us fix the issue if we can reproduce it.
Thanks,
Tanya / comments
Hi,
Does it happen consistently for a particular script?
If so, would it be possible for you to give us the script that is causing the exception as it would help us fix the issue if we can reproduc...
Hi Steve,
Layout needs valid SQL syntax before formatting your code. The question marks used as replaceable parameter values are treated as invalid characters and therefore the error is thrown.
However, I will log this as a feature request if you may wish and will keep you posted with updates on this feature?
I am sorry but this is how the product is currently designed to work.
Many thanks,
Tanya / comments
Hi Steve,
Layout needs valid SQL syntax before formatting your code. The question marks used as replaceable parameter values are treated as invalid characters and therefore the error is thrown.
How...