You are right. To format an SQL statement, AQT splits into it's indivudual parts then puts it back together. It looks like it cannot handle a Select statement...
I archive my SQL history by week. What I would ask is that the first 9 weeks of the year be padded with a zero so that they sort correctly in a file list....
If i have a query something like the one given below, what wud be the equivalent query in sybase. It doesnt work coz a table in sybase cannot be used in a...
Hi Phil, in the new Version some of the commands in menues have not underline- character, especially in the menues for the SQL-window. So it is not possible,...
Hi Installed Sybase4.1 and AQT 4.5 Created custome Database in sybase. Created Data source thru OLE DB Provider. Not able to connect Sybase thru AQT. Any help...
Hi Aruna Firstly, you are entitled to a free upgrade to AQT v7 Standard Edition, which you can download from http://www.querytool.com/download.html Secondly,...
I'm looking at the data compare portion of the AQT. I need 3 things that I'm not sure it does, and I can't really determine with the 100 row set limit without...
Hi there, You are right, AQT just reports on the number of differences found, but not further details (such as in one table but not the other, those in both...
Hi, I am using AQT for years and I REALLY appreciate it. One thing only, I've sceduled batchs on a remote pc to export data in a xls file. The thing is, the...
Hi Phil, I realiae that you're not really interested in addressing the minor issues before the 8 release but one thing I noticed today and thought I'd mention...
One other suggestion Phil, how about the commented out drops have a unique designator of some type so if you wished to uncomment them it would be a simple...
Hi Phil, I'm having to use AQT on a relatively low resolution screen. I'm working in the Run SQL window. I would really love to have more of the screen devoted...
You're quite right it isn't, however searching and replacing all --Drop, all --Alter and every other --Go in a script that's a couple thousand lines long gets...
Ah yes, GO not being commented out. Good point. Pretty simple to fix. Tables with FKs. What you can do here is to check the option "Generate the Foreign Key...
It looks to me like the problem is the comma in your CLOSEXL statement. Try removing that. You can also test it on your local machine so that you can see for...
Hi! I installed AQT - latest version (trial for now) on a user's desktop. When I run it there - it works well. When user logs in - she gets several errors in a...
It looks like one of the components used by AQT wasn't registered to Windows correctly. Find file ocx_register_v7.ocx in your AQT install directory and run...
Hi Phil, when starting a query and AQT is fetching the data, I can abort this process by clicking onto the abort-button or pressing <ESC>. But when the...
Add the parameter bulkmode=y to your export command. Eg. --aqt export,file="C:\aqt\output.xls",type=excel,filemode=replace, sheet=cust,bulkmode=y Phil....
No Phil, it does not work like that. Here is what I found is the best way to install it for users with no admin rights: 1. Connect to user's workstation under...
Hi Phil, In AQT 8: When viewing the text of procedures: Although (per right-click) the context menu tells us <CTRL+A> and <CTRL+F> should work, it does NOT....
Most of these functions only work when the procedure text has focus (you can tell this is the case because the Edit menu item is visible). By default the focus...
Phil, Forgot to write back to you on this but it has been working great! Any chance to make the "Synonyms on remote databases" persistent (some option screen...
The easiest thing would be for you to make a change to your config file oracle.cfg. Find the place in the file where it says: menu2;3;Synonym &List; All...
The biggest headache for a person, like me, who works from home may be the fall-out from poor connectivity. Frequently, when I try to execute the SQL, I am...
In AQT v8, there will be a Reconnect option in the Run SQL window, which is a more convenient window to have this option. You can even customise the toolbar to...
And can be downloaded from http://www.querytool.com/beta.html See http://www.querytool.com/aqtv8.html for the new features. Note that there are three changes...
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.
