The parameter replacement is very simplistic. Wherever it sees $prm_abc it replaces it with the value (eg. 1), irrespective of what string precedes or follows...
When using $ as parameter delimiter and given query: --aqt setparm,parm=prm_abc,value=1 --aqt setparm,parm=prm_abc1,value=2 select 1 from sysibm.sysdummy1...
Hi, I just did my AQT setup and I'm getting the following error: "The exception generated was c0000005 at address 0015CEA4 (<nosymbols>)" Any pointers how to...
Yes, you say --aqt setparm,parm=yesterday,value=$result(1) This will set the parm to the first value returned by the most-recent query run. I guess, long term,...
I know the AQT FAQ states that it does not support cross-database queries, but the Help text on AQT scripting functions states that for SetParm: You can set...
Yep, did all that. What I figured out was that within the Tools/Parameters window, just specify the field names without the leading colon or dollar sign; those...
Can you please tell me what is wrong with this coding? Tools/Parameters window: Parameter = :Stores Value = (3345, 3334, 317, 9319, 10529, 5524, 5704, 5916,...
Hi, To do this, use the DDL Generator. There is a basic version in AQT Standard Edition (Tools/Simple DDL Generator) for tables, and a more advanced version...
You do this by creating an Alias for that member. Eg: CREATE ALIAS myLibrary/myAlias FOR memberLibrary/memberFile(memberName) You then select from that Alias. ...
I've been using AQT 7.17 for quite some time. Lately I'm having troubles with scripting function called CloseXL. I want to use it in order to close excel file...
The Cols table of the SQL Window does not refresh existing tables when the "Build list-of-tables from SQL" button is pressed. I often work with large SQL...
That I am aware of it cannot be done. That I am aware of Teradata does not have a feature such as MS SQL Servers Linked Servers. I too work between three huge...
I have the following SQL and If I paste it into the SQL window and run it it works fine. However, if I paste it into the SQL window and then take the Format...
Hi there, most of the AQT settings are held in the Registry (in HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Cardett), so unless you saved the...
Hi, I have had to re-image my PC due to a major problem that had cropped up (not related to AQT). After the re-image, I installed the full 8.2.8 program which...
Phil, I've been away from the office a couple of weeks so I'm just now testing 8.2.9. The errorlevel is working pefectly now. Thanks for spending time...
Ah thanks Phil, I thought that parameter was still required. It now works perfectly !! Thank you so very much. If I every make it to New Zealand, dinner in...
Hi Phil, Sorry for not replying - I was away for a few days vacation. I moved the ver 8.2.9 program into the AQT Program Files folder, and renamed the ver...
Hi there, many functions are different between MS Access and SQL Server. Example functions are: DATEADD(day,-30,getdate()) plus DATEDIFF(day,datecol,getdate())...
Hello- I'm trying to learn AQT. I have this statement in my Access query that I'm trying to change over to AQT because I know it'll run faster. I tried to use...
I've spent several days on this and think I have a resolution. Basically I had to do a lot of code restructure so that, when running a batch script, AQT...
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.
