Comments
Sort by recent activity
I had the where clause editor set to use the same where clause in both tables. When I set it to pick "active" from one table I'm seeing what I expected.
Thank you / comments
I had the where clause editor set to use the same where clause in both tables. When I set it to pick "active" from one table I'm seeing what I expected.
Thank you
This would be useful - please consider letting a user manually map a differently named items in a future version.
Thank you / comments
This would be useful - please consider letting a user manually map a differently named items in a future version.
Thank you
I'm glad that you know about the issue. I will wait for your next release. I find many cases where Prompt gives me errors the SQL Server does not, particularly when a query accesses two databases, or runs from one database against another. I can see how these are tricky to deal with.
Thanks,
Alan / comments
I'm glad that you know about the issue. I will wait for your next release. I find many cases where Prompt gives me errors the SQL Server does not, particularly when a query accesses two databases...
A filter worked, but more painfully then it might have. I saw "Filter" in the upper right corner of the screen, and it did not work. Eventually I saw "Filter:" in the upper left, and was able to set up a filter. I chose to "include if begins with v_" and the filter included my views and many unwanted others beginning with "view__". Filters must ignore the underscore character (arthropod). The SQL code in the views was difficult to read because some had been formatted by the developer using SQL Prompt, and some had been created by the query designer and never formatted. At least I now have a list.
This would have been easier if the documentation had a few images and focused initially on the mechanics of adding and setting up filters rather than the capabilities of a filter.
Another very nice feature for a future version would add SQL Prompt formatting to code displayed by SQL Compare.
Thank you for your help. / comments
A filter worked, but more painfully then it might have. I saw "Filter" in the upper right corner of the screen, and it did not work. Eventually I saw "Filter:" in the upper left, and was able to ...