I'm using ADS 7.0.33 with Sybase ASE 15. I've set the Max Results to 10000 to discard any results after 10000 rows and prevent runaway queries from using up...
Hi John, Thanks for the explanation. You are right - it does not affect INSERT, UPDATE, or DELETE. I thought I had seen it do that but must have been something...
Hi, At the moment, 7.5 is feature complete and we are only working on memory optimizations. Memory seems to be the one feature everyone is interested in, so...
Hi everyone, I've been working with datastudio 7.0.35 to rebuild an oracle development database, and I have not been able to find an option to rebuild imported...
Hi, ... development database, and I have not been able to find an option to rebuild imported indexes. ADS doesn't have a GUI for this. You would need to...
I just started using ads so forgive the newbie question. How can i create a primary key (or unique constraint) on more than one field? In the Alter Table...
Hey, I don't think that the database will allow you to alter a constraint key like this. The best thing to do is drop your primary key and add another one. ADS...
Timothy Orme
torme@...
Mar 4, 2009 7:19 pm
7063
Hi, Tim is correct. You can't ALTER a constraint. You must drop the constraint and recreate a new one with the new definition. regards, -John...
This is a little odd in aqua too actually, but when adding a constraint, if you select the first column, and then press enter, it will add another. It's a...
Timothy Orme
torme@...
Mar 4, 2009 8:25 pm
7066
Hi, If you select a column, then click on the row and move the arrow key down you will get a second row. regards, -John...
Hi, We currently don't have a PDF version, although you can download the HTML version from here ... http://www.aquafold.com/downloads.html#docs We will try to...
In the Alter Table window, Tab moves the focus forward to the next field. Shift-Tab should move it backwards, like it does in many other apps, at least in...
Is there a way to categorize the tables in in the "My Schema->Tables" tree view? Ideally I would like to group tables into folders based on internal semantics....
Hi, I just entered a lengthy query into the editor and accidentally pressed the wrong button (personally I find "OK" left of "Cancel" difficult, I am somehow...
Michael, I whole-heartedly agree that its dangerous, and also down-right frustrating. I would like to see a program one day that could... - time how long you...
Hi Michael, ... used to have them the other way round) The order depends on the OS you are on, based on OS UI Guidlines. On OSX it is Cancel/OK, on others it...
Hi, We do have this on our list, but not to be as smart as you are describing. Sounds interesting, but it is just about prioritizing features based on demand...
John, is there a way to turn this off? Whenever you have a resultset you wish to view in the excel viewer it always creates the first column as "Row Count"....
Hi, When you copy to clipboard you can Copy, Copy w/ Headers and Copy w/ Headers and Row Count. When you view in Excel Viewer it will do a Copy w/ Headers and...
Hi, Below is a new patch with some minor bug fixes. thanks -John Patch: http://download.aquafold.com/download/v7.0.0/ads-7.0.36-patch.zip Update Instructions:...
I'm running the following script in ADS 6.5 and I'm getting a syntax error on the println command. Am I missing something simple? .println 'Report Title' GO ...
Are there any plans to support saving query results in the new Excel 2007 format? Support for > 65000 rows as well as smaller file sizes make this an...