Assuming you have a CASE function, and link the two records with a primary key (I'll call LINKREC), use the following code (FLD is whatever you are matching): ...
Hello all!!! I'm running AQT version 7.1.0 the full extended version on Windows 2000 connecting to DB2 UDB version 8.02 and am getting disconnected after a few...
I'm not sure what the cause of this problem might be. If this problem is easily reproducible, I suggest switching on an ODBC Trace (see Option > Technical...
I'm not sure what the problem here might be. Has anything changed on your PC? The error message doesn't mean much to me (AQT does refer to a property Let...
I knew the error message wasn't of any help, but unless you can't reproduce the problem in debug mode, this is the best I can do so far... A log file may help...
Phil, I've found part of the problem. I remember that AQT 6.1.7 Export to Excel worked because I gave a special attention to this feature when I decided to...
I'm glad that you have found a work-around which enables you to run the exports. Apart from defaulting the worksheet name to the table name, there is very...
You can do this by entering the delimiter as "tab" (but without the quotes). However I have realised that there is a bug with this that prevents it working...
I am running ver 7.1.1 will that work with it or do I need to wait for 7.1.2 Sam Jazaerli Director Of I/T I/S Buy from the source. No Connection Fees....
In version 7.1.1 you have the ability at the options to control window behavior. Most of the time I don't need new windows opening or any options checked...
Would it be too much trouble to add a date in the SQL History dialog in 7.1.2? You could stick it clear out to the right. It would occasionally be really...
Hello Phil, I emailed you in the past on this and we didn't find a solution. I am attaching to an Oracle 9.x server and using the Oracle 9.x Client ODBC...
Can you check the following: a) Options > Unicode Options. "Enable Unicode Features" should be checked. b) AQT comes with a demo database AQTDemo. This has a...
Hello Phil, I have a problem, that seems a little problem for other people, but is a big problem for me: When creating DDL-scripts, there are two ways to...
I presume you are comparing databases of different types. Different types of database have different rules about how the PK is defined. Some databases require...
Thank you for this quick answer! The Customer and I both are using DB2/UDB. In each case the DBs are running on a UNIX-system. The connection from AQT (running...
Hello Phil, perhaps you are right, the reason for the differences is certainly the _adm-file, AQT is using. Here are the Infos I've found in the heading of the...
Hello Phil, I'm glad to let you know I found the resolution! I've created a copy of my file db2udb_adm.cfg and made the following modifications: I've changed...
Hi, When I use either AQT 7.1.1 or AQT 6.1.6 with MyODBC 3.51.11.00 ODBC driver from the mysql.com site, I get the following error when I try to display Table...
Wow, you are very clever. You managed to figure it out, without any documentation to help you! DB2/6000 and DB2/Linux use the same cfg file. If your systems...
In answer to the question on Object Compare - are you using the new Object Compare that came with AQT v7. You start this by clicking on the Compare icon in the...
Oh! I must be blind for a few weeks... (at least on one eye). No! I have never tried this button... What a asininity! I was looking for the functions only in...
Hi, I posted a note yesterday that I was getting, with MySql 4.1.10a, the error: "Error Processing: Select Table_name, Table_priv, Grantor Timestamp from ...
OK. I've managed to slip this into V7.1.2 at the last moment. Phil. ... in 7.1.2? You could stick it clear out to the right. It would occasionally be...
And can be downloaded from http://www.querytool.com/aqt712.zip This feature mainly consists of bug fixes, however there are a few minor enhancements. One of...
Hi Phil, I just installed the new version 7.1.2 with the nice formating function. I got the following problem: When having more than one statement in the...
Dirk Reckeweg
dirk.reckeweg@...
Apr 12, 2005 9:24 am
1684
That's a good point. Not intentional, so I guess that makes it a bug. Thanks. Phil. ... function. ... them is...
The queries used by AQT for populating the Database Explorer are held in file mysql.cfg. I will research this problem - it can probably be resolved by amending...