Ah -- that has been on my very very short list of AQT annoyances --- ! Chris _____ From: aqt@yahoogroups.com [mailto:aqt@yahoogroups.com] On Behalf Of Phil ...
I have a 7 character field and need to exclude based on the last 3 characters. Does anyone know how i can do this? I'm worried that '%xxx' will exclude too...
Hi, At work today I have been running some queries and when the queries have been running, the "AQT Cancel" box which displays the running time of the query,...
Yes, AQT remembers the position of the windows between sessions. So if it has been dragged a long way to the right, it will reopen in that position. The...
Hi, I found a solution to my problem. If you right-click on the "AQT Cancel" icon that appears in the Program Tray at the bottom of the screen (along with the...
Hi, I am a big fan of the AQT program and it's many useful features. However, there is one issue that irks me and I thought it wouldn't hurt to ask, in case a...
Thanks, I guess we all learn something new on a given day From: aqt@yahoogroups.com [mailto:aqt@yahoogroups.com] On Behalf Of glen.wenzel Sent: Wednesday,...
Hi Glenn, this isn't all that easy to do. AQT doesn't know that the connection has been terminated until the next time it runs a statement. The only way to do...
Whenever I want to get a tab-delimited copy of a table, AQT makes it very convenient. I simply do a "select *" from the table and then copy a row, with the...
Are you just wanting to generate an SQL of the following format: select col1, col2, col3 from table There are two ways: a) select the table in the Database...
Thanks! That "Generate" window does the trick. I altered one of the settings to get this: select $fn(lcase,$3) from $1.$2 That's much better than my previous...
Hi Phil, IMO, the Link to related tables feature is one of the best additions to AQT in recent times. Because I use it often, I have three questions: 1) AQT...
Hi Luc, 1) You can increase the max number by going Options > Technical Parameters and increasing the value of "Max Tables in Query Builder". In the next...
Hey guys, I just started exploring this tool, and loving it so far. I am curious about the Analyse button on the toolbar when I go to edit my SQL statement....
How can I update a field in one or more rows with current_timestamp while in Edit mode? Now I get a messagebox. ... Advanced Query Tool ... Error updating row ...
Hi, For timestamp type in DB2, the timestamp format is: 2009-03-24-00.00.00.000000 (with no quotes). You can also try choosing "Update" from the main menu on...
Hi guys, I have been playing with the Group Calculation feature to obtain counts and averages of my data results. This works great on the screen. However,...
Hi, Sorry, at present this is not possible. When you export, just the raw data will be exported. It is not possible to export with the layout of the grouped...
I've just noticed this now and I was wondering if there is something that can be done to correct this without upgrading to the newest version? The tool has no...
Hi, Could you provide me with some more information? From the main menu: Help > Database Details - could you tell me what "Config File" AQT is using. Also, do...
I am using AQT to call a Stored Procedure on iSeries. One of the parameters is a 10MB CLOB. If I fill this with a large amount of data and then tries to run...
Hi, This is a general Informix SQL question. I have 2 date/time values (each is DATETIME YEAR TO MINUTE), and I would like to subtract them and get 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.
