Hi, I just started using Aqua Data Studio. It is amazing. I am dealing with SQL Server. I have one at my office and one at the hosting data center. I want to...
Hi Shuaib, ADS currently doesn't have a GUI for backup and restore for SQL Server. This is on my todo list but currently you would need to issue BACKUP/RESTORE...
You can backup/restore thru t-sql, so you should be able to do it thru ADS after a little bit of sifting thru SQL Server's books online. Here is a simple...
Playing with some of the new features just added to datastudio: colored grid, stop query processing on errors, field formatting, etc Datastudio is really...
Add this to your JTable's: table.setDragEnabled(true); Now, select a few lines in an output grid and drag them to excel or to word (or to open office? Haven't...
Hi Carlos, I have added this change and it works well. I can now drag-n-drop the selected cells into other apps. I tried Open Office and it doesn't work ...
Hi Carlos, ... Baby steps to perfection. :) ... 1) Text Results: If you are using Text Results, ADS needs to display the object results into the JEditorPane....
When I am working with PL/SQL in Oracle 9.2 I get very little feedback from errors. For example running a script in DataStudio provides the following message: ...
You can query user_errors to get that information. sqlplus does that for you and maybe the next version of aquadatastudio now as well. ... -- Regards Wolfgang...
Wolfgang Breitling
breitliw@...
Mar 2, 2005 4:39 pm
1848
Hi, Currently, in the Editor this is the only information that ADS displays. If you want to view the compile errors of the Procedure you can find the...
In an sql server session: select 'SYSTEM_USER', SYSTEM_USER Grid result: 1. No headers 2. Incorrect column sizes. This happened while trying to get the current...
1. File -> Options has P as mnemonic which is duplicated with Print. Suggestion: T as mnemonic. Also Mount and Unmonunt have no mnemonics. 2. When doing...
Hi Carlos, Here is a build with the fixes I mention below ... http://www.aquafold.com/download/datastudio_4_0_3_3.jar ... I added _M_ and _U_ for mount and...
Hi, I am using Sybase SQLAnywhere 9.0.1 on Mac OS X 10.3.8 with the lastest Java (1.4 update 2). I can browse my database schema but if I ctrl-click on a table...
Hi Colin, I just tried to do a "Alter Table" and "Edit Table Data" on a few of my tables on Sybase Anywhere 9 from OSX and they worked for me. I am using ADS...
First of all, thanks SO much for Aqua Data Studio - Great tool! I've been using it for about two weeks, and I have a few suggestions: 1. Recent files list:...
Hi John, I have had the problem on every table I have tried so far. I originally was using 4.0 but am now on 4.0.3 as part of my attempts to fix. I looked in...
I am trying to run data studio on a Fedora Core 3 machine, and when I run the shell script I get the following error. Is there anything I need to do in order...
Hi, From the error message, ADS is having problems extracting the constraints for the table. It works on all my sample constraints. I added a little more...
Hi Dave, ... last 10 files opened) I do have this on the todo list. ... You can already do this in File->Options->Query Analyzer. ... I am currently working on...
Hi, I just downloaded Aqua data studio and found a bug in the autocompletion. Here is whats happening. When I type the following: select * from employee e ...
John, Thanks for the help, that was it, I didn't have either of the openmotif packages installed. Thanks again for the quick response, Matt ... 3 ... ... ...
... can ... The "field.setDragEnabled(true);" worked for me for textfield's: could dnd inside the field and between [dnd enabled] fields in the same frame - so...
The message display output is a little to full of text ... select 'a', 'b' <<<< SQL Statement <<<< 1 record(s) selected [Fetch MetaData: 31/ms] [Fetch Data:...
... In _that_ case, you should remove most of the mnemonis, because there's some menu option conflict: S: Save Query and Server A: Save Query As and Automate ...
I was just reporting a bug in datastudio :-) ... Don't much like this slqserverism. I prefer standard sql: select 'system_user' as col1, system_user as col2 ...