Hi, I'm new to AQT and used to using SAS for data pull/analysis. When I run and SQL with a create table statement, it takes significantly longer than if I just...
With Access, the Create Table statement should only take a second or two. What has probably happened is that something else has the Access database locked, and...
I just installed 8.2.6 on a Windows 2003 64-bit O/S. Install seems to be fine, no problems reported, but it won't start at all. The only error I get is in the...
I made some progress and learned a few things, but it still won't run. 1) It installs into the c:\Program Files (x86) directory no matter what you tell the...
Could you try this: Windows has a feature called Data ExecutionProtection which is designed to prevent malicious code from running on a system. This feature is...
Thanks Troy! That seemed to do it, although I still had to run it out of the c:\Program Files directory - which is where I had to move it manually after the...
We have identified this as a bug. I have uploaded a cfg file (db2400_adm.cfg) to the Yahoo group to fix the problem: look under "Files" on the left-hand menu. ...
--Sorry ignore this message - I've replyed to the wrong email... ... move ... server ... in ... components ... yet ... Data ... all ... won't ... adjusted ... ...
Hey, When I use the "Compare Results" check my query result to another one, and I try to exclude a column in "Compare Cols", clicking on "Do Compare"...
Hi Phil, Â I have some more questions as below. Â 1. How can I execute continues 2Â SPs as below? Â Â Â Â Â Â { call <sp_name1> (100) } Â Â Â Â Â Â { call...
If you are running multiple statements, you must delimit them with semicolons. Eg. Â Â Â { call <sp_name1> (100) }; Â Â Â { call <sp_name2> (100) }; You can...
Hi Phil, Â I have removed the Statement Delimiter.settings from semicolon to none. In this case what I have to do? Â In the previous mail url says page canot...
If you are running multiple statements (as you are here), you will need to set Options > Statement Delimiter to Semicolon, and include a semi-colon between the...
I have a batch process that logs me in, runs some sql...but I need to export the results to an excel sheet in a particular folder that I link to in an access...
Does this help? --aqt export,file=c:\temp\export.csv,type=csv,filemode=replace,prompt=no Select * from customer; you can find more about the scripting options...
Searching messages in the group does not work. This is not an AQT issue, but apparantly a problem with Yahoo Groups, but it means that the group is quite...
Hi Phil - This is a strange one. I purchase a new monitor recently ... no problems with any program ... except ... In the main AQT window, I no longer see the...
Hi all, I am fairly new to the AQT software, so this may seem like a basic question. I have a list of about 5000 account numbers that I need to search for in a...
How about creating a table and inserting those 5000 or whatever account numbers. If they are in a text file, use the AQT data loader to quickly insert them. ...
Hi, If the account numbers are within a certain range then you could use one of the operators "Between" ">" "<". To do this, in the Query Builder window,...
Not sure why this might be happening .... certainly haven't seen it or had it reported before. One suggestion is to go to Options > General > Grid Colors and...
AQT is a great tool, but I'm missing some keyboard-shortcuts. In particular I'd like to have a keyboardshortcut that puts focus to (and eventually selects all...
I'm trying to export directly from SQL generated in AQT to a different database on our network. I can not get the Export options to consistently show up from...
Just to clarify.... are you in the Run SQL window, and have you clicked on Export to Table? If so, is the problem that the "Export data to Table" dialog takes...
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.
