Sorry you didn't get my earlier reply (must have gotten lost somewhere). I presume you are referring to the fix whereby AQT will correctly interpret a join...
I am trying to convert a field which holds a proper name (all in uppercase) to the appropriate upper/lowercase. For example, I need to convert "MARY ANNE" to...
Most databases do not have an inbuilt function to do this. However if you let me know what type of database you are using, I'll be able to let you know for...
Utilizing DB2 (and the SAMPLE Database), Here is an example: SELECT RTRIM(SUBSTR(RTRIM(UCASE(SUBSTR(E.LASTNAME,1,1))||LCASE(SUBSTR(E.LASTNAME,2,14)))||', '|| ...
Thank you so much. This is the sql statement I used: UPDATE MSTR SET FIRST_NAME =                     UCASE(SUBSTR(FIRST_NAME,1,1)) ||...
DB2 doesn't provide an easy way to do this. The only real way to do this is to write a user-defined-function to convert the string to the capitalize case. You...
I suspected as much. Thanks so much for everyone's help. Coleen ... From: Phil Castle <group@...> To: aqt@yahoogroups.com Sent: Monday, February 5,...
AQT 8.1.5: aqt.exe - Application Error The instruction at "0x734fee9b" referenced memory at "0x00000010". The memory could not be "read". Click on OK to...
AQT 8.1.5: aqt.exe - Application Error The instruction at "0x734fee9b" referenced memory at "0x00000010". The memory could not be "read". Click on OK to...
This is a known problem with batch mode, which we haven't resolved yet. When a batch script terminates prematurely, AQT calls a Windows API to terminate the...
I was usaing AQT 7.1.6 to run a SQL script which has a loop in there to insert multiple records into a temp table. The Run Multiple SQL Statements window shows...
I currently query large DB2 tables by using Microsoft Access and linking via ODBC. It works well for the small tables, but when I have to work with large...
MS Access is *very* resource intensive when accessing large tables, or a system with a lot of tables. This is not due to ODBC per se, but the way Access...
When you run SQL in AQT, it gets passed straight through to the database. You can only use functions etc which are valid for DB2. DB2 doesn't have the IIF...
There is a limit on how much text can be written to the status bar. If you go to the History window you can see the full text (or at least the first 10k...
Hi THats what I figured. I played around with the demo today...but it returns the first 50 rows and I need to test it against a real big table to watch its...
We will email you a time-limited key that has full access to AQT. Phil. ... returns ... purchase.... ... Phil ... the ... "Firebird" ... Behalf Of ... tables, ...
I am running AQT 8.1.5 and just recently upgraded to Windows Vista. Now I can't run AQT. When I try to run it I get the following error: Error initialising...
We haven't yet tested AQT with Vista, though we will do this soon. Try running the following commands in a cmd window: regsvr32 /u C:\Program Files\Advanced...
Hi Phil, Very pleased with the new functionality in v8, but I would like to raise some usability issues concerning "Favorites": In the "add muliple objects"...
Hi Phil, When creating a new folder, the "standard" folder "db" can be overwritten. When you do this, a (logically) corrupt fav*.txt file is created. The...
Hi Phil, In my opinion it would be better if all the text in the filter box be automatically selected with a single click ("on receive focus"), so that the...
Thanks, will fix some of these things. In Organize Favorites, multiple drag/drop and multiple delete is not possible as the Treeview component only allows a...
Will change the filterbox to highlight the text when it has received focus. There are many places in AQT where double-clicking a textbox will show you a bigger...
I am running aqt 8.1.5 with vista and office 2007 if I click on either the export icon or the menu option for export. AQT shuts down with no error message is...
You can enable debugging with Options > General > Debug. One possibility is that you don't have access to create files in the default location for export files...
As always thank you for the quick reply. I enabled debugging and this is what I get. AQT shuts down as soon as I click on the export icon or file export...
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.
