... Okay, I updated to 6.0.21. By the way I found that I had to reboot my Windows XP machine to make the new ADS jar file take effect. When I first tried ADS...
Hi Robert, ... make the new ADS jar file take effect All you need to do is stop the ADS application, update and then restart ADS. If you update the .jar files...
... John, Thanks for the response, and sorry I haven't followed up -- ended up sidetracked on a couple of other items. I will pull a couple of screenshots to...
Hello John, if altered some roles for a user on a specific database with the security manager. After applying the changes, under the General Tab the new...
Hi, I was wondering if this feature had been requested or if y'all had plans... I would like ADS to execute the currently selected text, irrespective of its...
Is it possible for the numbered list of statements to maintain focus on the currently selected history item, even after a new statement is added? Here's the...
Hi Will, I will put this request in the feature list. I think some users want it one way, and other another, so we might have to make this configurable. ...
Hi, You can use the "SQL History" in the application toolbar to get the SQL statement, although you won't get the rows of data that was returned. -John...
John, Just curious if there is a way to default the query analyzer window so that the Editor Tab starts out fully expanded and the results tab only shows up if...
Hi Jason, You can't do that, but you can Ctrl-Alt-F7 (Windows->MutiTab/SplitPane) which will give you a full screen and separate tabs for results. -John...
I'm pretty sure there's a good reason... I was wondering why there is a difference between what ADS reports as errors and what SQL Query Analyzer/Golden/SQL...
John, Here's a contrived example T-SQL (could be part of a procedure, too) that demonstrates this error: DECLARE @strFraction varchar(8000) --to fix, just...
Hi Will, This new build will print out all the errors, but I don't think it contains the one thing you want, which is the line number. The line number isn't...
John, Perfect, it works great. I gathered the line numbers weren't being provided by the driver. Oh well, can't have everything! Thanks, Will John LH wrote: Hi...
using ADS v 6.0.21 SQL 2005 In Alter Table options changing a default value parameter to a column with already set/added default parameter ADS tries to add a...
Thanks for the fix John ... From: aquadatastudio@yahoogroups.com [mailto:aquadatastudio@yahoogroups.com]On Behalf Of John LH Sent: Wednesday, June 13, 2007...
Is there a way to get the columns ACCESS_PREDICATES, FILTER_PREDICATES, and PROJECTION to appear in the output for Explain Plan with Oracle, in ADS? Either in...
Hi John, Just downloaded the new ADS and was looking for new things. Found the schema diff tool and this is absolutely fantastic!!! This saves quite some time...