Hi there, AQT is written in Visual Basic V6, which is 32-bit only. We are currently porting AQT to the VB.Net environment, which may enable a 64-bit version of...
Can I use AQT to connect to Oracle instances that use LDAP and not a tnsnames.ora file? I can connect with TOAD, but not AQT,and I want to use AQT (I have a...
AQT version 8.2.2 I expect --aqt closeXL to terminate with a return code of 0 but running below script returns 8, though the script closes the spreadsheet with...
Hi, We have seen a similar problem which has been fixed in the latest release of AQT. Go to: http://www.querytool.com/download.html - download and install AQT...
Thanks for confirming the problem. Regrettably it is not as simple as a download URL to upgrade. It takes approx. 6 months for us to go through an upgrade...
When running Print Grid from Results of Data Compare, I expect to get both tables' rows (show only differences selected), but only get the table on the right. ...
Hi, Yes, two grids cannot be printed at the same time. You can print the two grids separately (whatever grid is selected will be printed). Select a cell or a...
Hi, In you SQL you could add: --aqt options, stoponerror=no this will allow your script to keep running without stopping. Regards. -- Troy Pascoe Technical...
In Oracle 10G when clicking on the roles tab I get Query failed with: S0002(942)[Oracle][ODBC][Ora]ORA-00942: table or view does not exist I get the same...
Hi, To view Roles, you will need access to the Views: SYS.DBA_ROLES, SYS.DBA_ROLE_PRIVS and SYS.DBA_SYS_PRIVS Regards. -- Troy Pascoe Technical Support Cardett...
Can the arrow keys be set to move through the database list, rather than the radio buttons? Normal behaviour is to Tab through radio buttons, and arrow a...
Hello, After upgrading to v8, I've encountered two issues which appear to occur only when writing data to a hidden worksheet: 1. Numbers are treated as text 2....
Hi, It appears to be a quirk with Excel as AQT produces the same script whether a worksheet is hidden or not. If you set: bulkmode=n in your SQL file, this may...
No, it's not possible to do this (to my knowledge). What type of database it is? Many databases have free ODBC Drivers that you can use to access the...
The Keywords, Cols,... tab in the SQL editor only picks up the first table mentioned in a Copied query from SQL History. To wit: I click on the SQL button...
AQT doesn't recognise the WITH syntax for queries, which may explain why you are not seeing this working. Phil. ... first ... click on ... History ... at ... ...
I later tried a join. Typed in the first table SELECT, then the join phrase for the second table, hit the twirly, but still only one table in the drop down...
When I move the following sql to designer and try and run it I get the following error message: 37000(107)[Microsoft][ODBC SQL Server Driver][SQL Server]The...
Can you send me a screenshot of the Query Builder window after you have imported the SQL into it. In particular I would like to see the (faulty) SQL at the...
Hi, im new to this program, just downloaded it today and having the trial version. So far i like it, but came up with 2 issues during the day. Im using Sybase...
Hi there, These are all issues that we haven't heard being reported by other people. I haven't noticed text wrapping, and the PK and FK displays normally work...
AQT can't, per se, run a query which involves tables in more than one database. You can however do what you want by defining an Oracle DBLink to the Sybase...
I started to use the Loader to populate Oracle tables (via inserts) from Excel spreadsheet (xls) and so far I run into 3 issues: 1) I have dates in US Locale...
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.
