The cases I'm seeing it most have various translations and some hard-coded values happening in the mapping page. The select query almost always has a...
It looks like there is a bug with the way AQT retains the mapping when you switch to a new table (especialy if the number of cols is different). I'll correct...
Thanks for the screenshots - that has certainly helped me understand the issues for you. I have created a build of AQT with some improvements in this behaviour...
The new version is a definate improvement for just changing the database selection. Another similar issue exists if I bring up a saved loader script (again...
This worked OK for me, however it relied on some windows-events being fired in a certain order. On some machines the events happen in a different order (don't...
I would like to request a feature for AQT to allow a selection criterial in the left outer clause. Right now it does not seem to handle this in GUI screen. ...
We recently upgraded to version 8.1.6 and I thought that would kill my load problem ;-) But I still get the annoying "Object variable or With block variable...
This was fixed in AQT v8.1.8. So if you upgrade to this or a more recent release the problem will be fixed. Phil. ... my ... With ... and ... commands. ... ...
Hi, I am trying to optimize a SELECT query with a WITH clause (Oracle db v9 R2) but it doesn't work. AQT returns the message "SQL executed OK", as if it were...
this is embarrassing :) there are these icons things near the top of the edit pane. and well, you can click on them, and one of them puts a data result grid...
A lot longer than I've worked here. So over a year. -- Troy Pascoe Technical Support Cardett Associates Ltd troy@... ... of ... puts ... another ... ...
Me again, I just found the reason: the ODBC driver was probably not the right one. I switched from "Microsoft ODBC for Oracle" to "Oracle in OraHome92" and now...
I found out the there was a bug with the Oracle WITH clause which was fixed in AQTv8.1.6, so downloading the latest release may have fixed this problem also. ...
Hi I am using AQT 8.2.2 on Sybase 12.5 - I just upgraded my AQT version last week When I go to the Columns branch I get "no objects displayed" I have rights to...
Checked this list and help first, but couldn't find a way (or that it's not doable) to have more than one filtering expression. Situation: on SQLServer,...
Love the product. One of the things I use it for is to generate spreadsheets. The ability to save queries works well, but then when I go to export, there's...
We just migrated to a new AS400. Now when I click on a table, I get the following error when trying to display column information for that table: Get Columns...
Hi, Can you go to Options > General - and select "Debug Mode", reproduce the problem, and send me the Debug File? Thanks in advance. -- Troy Pascoe Technical...
Hi, In the Export window go to File/Gernerate fast export script. Is this what you had in mind? -- Troy Pascoe Technical Support Cardett Associates Ltd ...
Hi, Can you try: Options > Table Information > Parameter Usage to "Use Substitution". Regards. -- Troy Pascoe Technical Support Cardett Associates Ltd ...
AQT 823, Sybase ASE, ASA Hi Phil, If i use the 'format sql' utility on this statement: SELECT t2.Land_Key, t2.RAAS_Tontraeger_Kat_Kz, t2.Produkt_Familie_Nr, ...
I'm an AQT newbie. Is there a trick to sending shell commands through the MySQL ODBC driver to Linux? I'm trying this without success: \! rm -f /file1.csv; ...
Hello, I've been using AQT for a while now successfully with SQL Server Db's. However, I've moved to a peoplesoft environment using Oracle db. I set up a ODBC...
Hi, Sorry, I'm not a Linux user, and AQT is designed for windows, but I will pass this on to Phil -Development Manager - unfoturnately he is on holiday at the...
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.
