Hi, I've got a small problem with aqt version 5.5.3. Sometimes when you try to copy cels from a resultset you get the following message: Error copying text:...
I've got all my prompting working. I wanted to add the ability to prompt for user and password, but I don't know where to put the connect or conn function....
AQT V5.5.3 has a bug that prevents the running of Stored Procedures to work correctly. We regard this as a serious problem and have corrected it; this fix is...
Thankz Phil, What a great service. And what a great tool: AQT. Huub ... to work correctly. We regard this as a serious problem and have corrected it; this fix...
Hello Phil, there is a problem when trying to display binary data (e.g. jpg). The data-colun is shown in hex-format. When trying to use right mous-click, view...
To view large binary columns, including jpegs, use Options->Lob Options. Set How to Display Lobs to Send to Files. This will export all the LOB values as a...
Just installed the v5.5.4. Excel problem still exist. My batch file call a SQL file to export the results to an Excel file. When the batch file finished, I...
I am building the database backend to an application and am using AQT as my main database tool. It is EXCELLENT!! This said, one task I must go outside of AQT...
There is a way of doing what you want, though it is a little work to set up= .
What you need to do is to set up an ODBC datasource for your text files. Yo= u...
Thanks so much. Believe it or not I did figure this out after using some basic logic (guess the brain wasn't working too well that day). Sorry for asking...
Thanks Phil. I had already made the ODBC connection to the Text file. I did not know you could have multiple files in the folder. Very useful, thanks. I have...
There is no unlimited per se. Just code maxrows=10000000. As for your other point, this has already been implemented. In V5.5.4 there is an option on the...
Excellent Gavin ... V5.5.4 there is an option on the Export Data window, Tools->Generate Batch Control Statement. This will generate an --aqt output control ...
AARRGGHH I have just upgraded to the latest AQT. Nice. However I am getting errors. I know there are 65700 records in the query to be exported and it seems to...
Hi, Great tool. Exploring the use of the "Generate DDL" functionality. It does not seem to generate the full sql statement that is needed for the table...
At this stage, the gen DDL function of AQT is "basic". It does not generate the things you list here (plus others). This is due to be rectified in V6 which...
Thank you. What happened? A row identifier defined as an integer instead of a long. I had this very thing in an application I have written in MS Access. Ran...
A note for those who wish to access Excel files from AQT. I have just discovered how to do this. When AQT was first written (many years ago) it was able to...
I spend a lot of time at the 'Run SQL' screen where you can write a query with the boxes below having different SQL choices. It really speeds up typing. I've...
I am using the following connection string with the user name blanked out for security: --aqt connect,dbs=uxfnc01i,user=xxxxx;epwd=HjFlJjFkBaGlAlJkAkEkEkJg The...
I have found that if you log into your database manually with AQT and then at the opening screen click the "database properties"(pic of a hand and paper), it...
Thanks - I discovered that I had a syntaxtical typographical #!$#!% error! --aqt connect,dbs=uxfnc01i,user=xxxxx;epwd=HjFlJjFkBaGlAlJkAkEkEkJg The semicolon...
I'm using Windows 2000 Professional and the latest AQT version. When using the 'export data' option on the 'run sql' screen I am opting for AQT to save the...
People have reported similar problems. The problem is that AQT has only a "loose" control of Excel. It can pass commands to it (start up, open worksheet, shut...
The problem is that excel stays active, after you close it when it was invoked by aqt(look in your taskmanager and you will find an excel.exe active). When you...
I sent an email to the AQT Beta email address with an attachment of the debug file. polson03 is right, even though you shut down Excel, if AQT called it, it...
Yes you are all right. I have found that the way I am doing something is preventing Excel from shutting down correctly. Will fix this (one line of code) - and...
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.
