Is AS/400 spool file store in database ? if yes, Can i use ADT to open AS/400 spool file ? Thanks __________________________________________________ Do you...
I can't get the data from tables in Informix that have a spatial component. Is this a limitation of AQT (the first I have found) or some form of Conflict. ...
I don't have much experience with Informix Spatial so I cannot comment directly. However if you switch on Options->Debug Mode, reproduce the problem, then send...
... Bay to escape Wellington's vigorous climate. See http://www.querytool.com/images/officeview.jpg for the view from our office. ... making us northern...
I have created some 70,000 Insert statements to load a set of data into a database (please do not ask why) and when I was running the 3rd 10,000 set into the...
I have discovered if I do not use a 'Select * from crs_parcel' but instead specifiy each field it is okay. I believe the field with the spatial object is...
Just noticed tyhe link to your office view image is broken. Gavin ... comment directly. However if you switch on Options->Debug Mode, reproduce the problem,...
Yes, can I have a screenshot of the Overflow error please. Email this to me at phil@... (rather than trying to post this to the group). Thanks, Phil....
It can be downloaded from http://www.querytool.com/download.html Let me know if you have any problems of questions with this. The following describes what is...
Phil - need a small change or addition for SQLBase users! SQLBase uses a "SQL.INI" file and yours is getting in the way. Using "Options", I tried Editing and...
I am a bit surprised that there is a conflict. The sql.ini that AQT uses is in the AQT install directory, whereas the sql.ini that SQLBase uses is in the...
Apparently SQLBase looks in the current directory when attempting to connnect BEFORE it checks the path statement (let alone its registry entry which should be...
Hi! Hi! Please show me how to use the Parms in the AQT SQL script. This is an example of one of my queries in my AQT SQL script where I would like to use Parms...
Hi! I have an AQT SQL Script which runs a dozen queries. I have been able to export the results of the queries to separate csv files which I am able to open in...
If I understand this question - you want all the AQT queries to go the *same* csv file, but when you open this file in Excel, you want the different query...
Hi, I'm struggling with this problem too. I changed all my outputs to excel, but it created a separate excel file for each query, instead of separate ...
Ramona, If you change the aqt outfile to have the same file name, filemode=append, and header=YES for each query you will get all of the queries in one ...
When specifing your Excel file name, make sure you use a fully-qualified file name. If you do not use a fully qualified file name, AQT sometimes has trouble...
Phil, Thanks for your prompt response. I did change my .sql file to export my query results to Excel spreadsheets. The nice formatting was an added bonus. I...
There was a bug or two with writing to Excel file in batch mode. I have fixed these in AQT V5.5.1 Beta, which I have just uploaded to our download page...
This build fixes the one or two problems that have been reported. This includes changing the syntax file from sql.ini to aqt.ini to prevent a conflict with...
Is it possible to set up an AQT script that will prompt for certain variables? I have one basic script that needs to be run for several clients. Right now...
Those who have downloaded the new version of the Beta may have noticed that the syntax highlighting has "disappeared'. This is a minor bug that only affects...
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.
