Search the web
Sign In
New User? Sign Up
aqt · Advanced Query Tool Discussion Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 4050 - 4079 of 4213   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
4050
We are running on SQL Server 2000 and I have the column display at 1000. Related question, even if the column display was set too low would you not see all of...
dbdonker
Offline Send Email
May 1, 2009
12:18 pm
4051
This might be out there already, but search isn't working. Please, add closing a tab with middle click. Tabs accumulate very quickly, and the methods to close...
Tony Matous
tmatous
Offline Send Email
May 2, 2009
5:25 am
4052
Not sure if there is another way to get this done, but if I try to paste the CREATE statement for a stored procedure in the SQL window, AQT tries to split it...
Tony Matous
tmatous
Offline Send Email
May 2, 2009
5:26 am
4053
It would be helpful to be able to open multiple Compare Data windows. Running a compare can take a long time, and it would be nice to be able to run another...
Tony Matous
tmatous
Offline Send Email
May 2, 2009
5:26 am
4054
Is there a way to generate standard SQL from a table, e.g. SELECT, INSERT, UPDATE, CREATE, etc? It would be helpful as a right-click from the table name in the...
Tony Matous
tmatous
Offline Send Email
May 2, 2009
5:26 am
4055
You can close a tab with Right-click > Close. Or you can right-click > Selective Close to close a bunch of windows. Search seems OK to me. Are you referring to...
Phil Castle
cardettnz
Offline Send Email
May 2, 2009
6:44 am
4056
Yes, go to Options > Run SQL and change Statement Delimiter to None. Phil....
Phil Castle
cardettnz
Offline Send Email
May 2, 2009
6:46 am
4057
That sounds like a good idea. I'll add it to our list of possible enhancements. In the meantime you can do this by having more than one AQT session. Running...
Phil Castle
cardettnz
Offline Send Email
May 2, 2009
6:57 am
4058
Not per se, however these can all be done in one way or another. Select. Select a table then click on Query Builder. If this just shows "select * from table",...
Phil Castle
cardettnz
Offline Send Email
May 2, 2009
7:13 am
4059
Not sure why this might be happening. I've tested this on our SQL Server 2000 system and it works OK there. When you switch to update mode, you just see the...
Phil Castle
cardettnz
Offline Send Email
May 2, 2009
7:48 am
4060
Sorry, I was talking about the search in Yahoo groups. Yes, I know about Selective Close and right-click close. Right click takes too long, and requires more...
Tony Matous
tmatous
Offline Send Email
May 2, 2009
5:18 pm
4061
I tried that, and it doesn't split them up but the script still doesn't run. If I paste it into SQL Server Management Studio, it works. I hate having to keep...
Tony Matous
tmatous
Offline Send Email
May 2, 2009
5:27 pm
4062
Ah, I didn't think about the insert/update dialog. Works for me, thanks....
Tony Matous
tmatous
Offline Send Email
May 2, 2009
5:30 pm
4063
Yes, the search in the Yahoo group is very poor. You can search the group using Google and the site keyword. Example: db2...
Phil Castle
cardettnz
Offline Send Email
May 2, 2009
9:37 pm
4064
Ah, go to Options > Run SQL and change Statement Delimiter to GO. In addition, you need to go to Options > Technical Parameters and select Use SQLExecDirect. ...
Phil Castle
cardettnz
Offline Send Email
May 3, 2009
10:06 am
4065
After the installation of AQT 8.27, I receive the error:Error initializing AQT: Component 'XpNetMenu.ocx' or one of its dependencies not correctly registered:...
roland_schramme
Offline Send Email
May 12, 2009
8:16 pm
4066
If you are running AQT on Windows Server 2008 or Vista you may need to disable a feature called Data Execution Protection. This issue is described in...
Phil Castle
cardettnz
Offline Send Email
May 12, 2009
8:23 pm
4067
Hi, I´m having serious problems with exporting data from an Oracle database as insert statements: one table cloumn is defined as VARCHAR2-type. This field...
peter.henkel@...
peter.henkel...
Offline Send Email
May 13, 2009
8:10 pm
4068
Hi there, there is no way of replacing the line-breaks with /n characters. However I've generally found this not be a problem when generating insert...
Phil Castle
cardettnz
Offline Send Email
May 13, 2009
8:49 pm
4069
Hi, the problem with the line breaks comes if you want to start the sql-script from sqlplus. Sqlplus doesn´t cope with the line breaks. But your suggestion...
peter.henkel@...
peter.henkel...
Offline Send Email
May 14, 2009
12:14 pm
4070
Hi Phil, I have AQT v 8.2.5. Can I upgrade directly to 8.2.7 or do I need to do 8.2.6 and then 8.2.7. Thanks Daniel To: aqt@yahoogroups.com From:...
daniel gomes
danvgomes
Offline Send Email
May 18, 2009
5:36 pm
4071
I'm evaluating AQT and could not determine how to modify existing stored procedures nor create new stored procedures in Firebird. My database is Firebird...
dkeith2
Offline Send Email
May 20, 2009
10:19 pm
4072
Hi there, We haven't yet configured the AQT admin system for Interbase / Firebird. So the Stored Procedure builder isn't available for this database. For...
Phil Castle
cardettnz
Offline Send Email
May 21, 2009
9:03 pm
4073
Hi Phil, i don't know if it is a problem of AQT/Windows Server 2003/DB2. Situation: i am running Batch AQT-Scripts (using scheduled tasks) on Windows Server...
dbfan111
Offline Send Email
May 25, 2009
1:52 pm
4074
For some reason, AQT is running low on memory. I can't imagine this would be due to changing to a new version of DB2. This could happen if you have a lot of...
Phil Castle
cardettnz
Offline Send Email
May 25, 2009
9:20 pm
4075
Greetings, When the "Save Password" feature is used in AQT under Database Signon, is the password saved in the Registry for the user? I'm assuming its...
steve.boyce@...
steve.boyce...
Offline Send Email
May 26, 2009
8:55 pm
4076
Yes. It is saved in the Registry, and is encrypted using Windows encryption services. Phil....
Phil Castle
cardettnz
Offline Send Email
May 26, 2009
9:02 pm
4077
I use AQT on DB2 iSeries tables (iSeries Files) that are created "natively" not via SQL CREATE operations. These tables (Files) do not contain iSeries...
Orlando Solis
osolis
Offline Send Email
May 29, 2009
8:47 pm
4078
Hi Phil, Following up on this old post. Would it be possible to have AQT make an automatic re-connection in cases where you have clicked on the "Run" button...
glen.wenzel
Offline Send Email
May 29, 2009
10:07 pm
4079
If you look at http://www.querytool.com/help/876.htm there are some notes on this problem. Phil....
Phil Castle
cardettnz
Offline Send Email
May 30, 2009
4:17 pm
Messages 4050 - 4079 of 4213   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help