Hello, After upgrading to v8, I've encountered two issues which appear to occur only when writing data to a hidden worksheet: 1. Numbers are treated as text 2....
Hi, It appears to be a quirk with Excel as AQT produces the same script whether a worksheet is hidden or not. If you set: bulkmode=n in your SQL file, this may...
No, it's not possible to do this (to my knowledge). What type of database it is? Many databases have free ODBC Drivers that you can use to access the...
The Keywords, Cols,... tab in the SQL editor only picks up the first table mentioned in a Copied query from SQL History. To wit: I click on the SQL button...
AQT doesn't recognise the WITH syntax for queries, which may explain why you are not seeing this working. Phil. ... first ... click on ... History ... at ... ...
I later tried a join. Typed in the first table SELECT, then the join phrase for the second table, hit the twirly, but still only one table in the drop down...
When I move the following sql to designer and try and run it I get the following error message: 37000(107)[Microsoft][ODBC SQL Server Driver][SQL Server]The...
Can you send me a screenshot of the Query Builder window after you have imported the SQL into it. In particular I would like to see the (faulty) SQL at the...
Hi, im new to this program, just downloaded it today and having the trial version. So far i like it, but came up with 2 issues during the day. Im using Sybase...
Hi there, These are all issues that we haven't heard being reported by other people. I haven't noticed text wrapping, and the PK and FK displays normally work...
AQT can't, per se, run a query which involves tables in more than one database. You can however do what you want by defining an Oracle DBLink to the Sybase...
I started to use the Loader to populate Oracle tables (via inserts) from Excel spreadsheet (xls) and so far I run into 3 issues: 1) I have dates in US Locale...
OK. In response to the problems. Stored Procedure Text AQT issues the query: SELECT text FROM dbo.syscomments WHERE id=? AND texttype = 0 ORDER BY SELECT...
Hi, 1. I havn't been able to reproduce this behaviour. I was wondering if you could go to: Options > General – and select Debug Mode. Also, could you go to: ...
Hi Michal, Here's some updates on your problems: 1. There do appear to be a few bugs here that we will look into. It the meantime it should work if you change...
It seems its this only one procedure that is messed up somehow. Cant duplicate it on any other SP, so far anyway. The issue with the FK/PK still remains. Any...
The PK query is complicated, and I'm not sure which bit of it might be causing the problem. To start with, could you run the following query: SELECT i.indid,...
Hi, Thanks for pointing this out. There is an error in the query. We will send you a fix. Regards. -- Troy Pascoe Technical Support Cardett Associates Ltd ...
Hi, Sorry, this is not possible. When you export, just the raw data will be exported. It is not possible to export with the layout of the grouped data. ...
I'm not sure what happened here, possibly one of my options was changed accidentally. Problem occurs when I attempt to run multiple sql statements. Used to be...
Looks like your divider between the textbox, showing the current selected row, has been dragged over the grid displaying your three SQL statements. Try...
Yes, that was it. Thanks! ________________________________ From: aqt@yahoogroups.com [mailto:aqt@yahoogroups.com] On Behalf Of cardett_troy Sent: Monday, July...
Documentation says AQT batch has 2 parms, one optional: aqt infile logfile I hope there is already a way to do this. I would like additional parms we can use...
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.
