Phil, I think there's lots of us that would love to see a solution for that crash. If the error occurs when AQT tries to set the errorlevel, then what about...
Hi, is there any way to run / link to AQT within Excel.. ie.. with Excel open run a query within AQT and return results to the open Excel document with the...
As with AQT v8.2.8, you can prevent the crash by setting: --aqt options,setexitcode=no however AQT then doesn't set the exit code so your batch script can tell...
Hi Everyone nice to meet you through this forum. I am using teradata . I have tables in two different teradata servers. Is it possible for me to access tables...
Hi there, AQT can't join tables which are in more than one database, unless Teradata provides a means to do this (I'm not an expert on Teradata so cannot...
Looks like we will moving to Google Apps, First I am not real familar with Google apps, but will AQT be able to write to the spreadsheet feature in Google aps,...
Hi, As far as I know, there doesn't appear to be a way to interface with Google Apps directly. However, you can import a .csv file into Google spreadsheet....
v 8.2.8 2 Questions: 1) is there a setting for auto-sizing result grid columns ? so that in this picture: http://imgur.com/6ukOx.jpg "CURRENCY_CD" column...
Hi, 1. There is no auto-sizing option, but you can resize the column and AQT will remember the width setting the next time you open the table. Also, you can...
Hi Phil, This site: http://www.codeguru.com/forum/showthread.php?t=253791 suggests that this VB code will work to set the ERRORLEVEL value: Option Explicit ...
I get the following error when trying to update a row(for a JDEdwards table F4101). Our database is DB2. S1000(-7008)[IBM][iSeries Access ODBC Driver][DB2...
The reason is that you don't have journalling set on for the database and, by default, AQT runs the update within a transaction. If you go to Options > Run SQL...
I've spent several days on this and think I have a resolution. Basically I had to do a lot of code restructure so that, when running a batch script, AQT...
Hello- I'm trying to learn AQT. I have this statement in my Access query that I'm trying to change over to AQT because I know it'll run faster. I tried to use...
Hi there, many functions are different between MS Access and SQL Server. Example functions are: DATEADD(day,-30,getdate()) plus DATEDIFF(day,datecol,getdate())...
Hi Phil, Sorry for not replying - I was away for a few days vacation. I moved the ver 8.2.9 program into the AQT Program Files folder, and renamed the ver...
Ah thanks Phil, I thought that parameter was still required. It now works perfectly !! Thank you so very much. If I every make it to New Zealand, dinner in...
Phil, I've been away from the office a couple of weeks so I'm just now testing 8.2.9. The errorlevel is working pefectly now. Thanks for spending time...
Hi, I have had to re-image my PC due to a major problem that had cropped up (not related to AQT). After the re-image, I installed the full 8.2.8 program which...
Hi there, most of the AQT settings are held in the Registry (in HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Cardett), so unless you saved the...
I have the following SQL and If I paste it into the SQL window and run it it works fine. However, if I paste it into the SQL window and then take the Format...
That I am aware of it cannot be done. That I am aware of Teradata does not have a feature such as MS SQL Servers Linked Servers. I too work between three huge...
The Cols table of the SQL Window does not refresh existing tables when the "Build list-of-tables from SQL" button is pressed. I often work with large SQL...
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.
