When I am writing a summary query in designer (Oracle) the only functions that appear in the drop down are count;min;max regardless of the field attributes....
Yes, this is annoying. This is due to the behaviour of the Microsoft Help System. We have tried, without success, to find a setting that prevents it behaving...
I guess you have a point. In a group-by query, there are two types of columns: a) those you are summarising. For these, min, max etc are the main functions you...
Hello Everyone, We are delivering this application through a Citrix environment and I am looking at removing some of the options on the login window and ...
Hi, I am having trouble logging on to one, and only one, of a few databases, I have accessed before with AQT. My coworker, who is also using AQT can access it...
This does sound like a issue with the way your client connection to that database has been configured. On the Oracle ODBC Driver configuration there is a...
Hi all, One of the neat features of AQT's results grid is the ability to drag a column header up and group by the results. Most of the time this works great....
You are right; I'm surprised that I haven't noticed it myself. After some testing, this looks like a bug in the grid control (when the column is dragged to the...
I just have a trouble on display Chinese character,it always some mark in the field. what I use is version 7 of AQT, and the Unicode option is enabled...
You currently get a little vertical-bar at the right of a field. This is when the field is wider than the grid-cell. This is a bug with the grid - it should be...
I'm a new user and I'm wondering if there is a way to have the GUI query builder list the columns available in a table alphabetically rather than by the order...
Yes you can. On the Options tab of the query builder, select Statement Type and change the Statement Type to Create View (and add the view name). Phil....
Seems OK now. Maybe it went out for a short time. We actually have a backup site http://www.advancedquerytool.com/ which you can use if querytool.com is down. ...
No, querytool.com is still down, but the backup site worked. Perhaps it's a problem with the connection from North America to the southern Pacific. I can't...
While playing with the new release, I stumbled on a round about way to format view SQL. This had been an annoying problem, as a view of any size comes out of...
The site is still up for me. Both sites are hosted in the US. Maybe something at your end is blocking it? Almost all the emails we have sent you in the last...
You sound like an expert with the viola. Sorry about being such a pedant (a bad habit of mine) - I'm sure you mean voila. The GUI Query Builder does a complete...
Hi Phil I'm not sure if you have already fixed this as I am not using the latest version. When I an in an output window and want to dynamically sort the view...
This is a known issue (that annoys me too). I have defined the sort-order for the column as being numeric. When the grid does the sort, it obviously gets very...
Phil: when it says 'V7 only', i guess it means it. kind of assumed it meant 'at least V7'. since we've upgraded our UDB installs to 8.1.X, and 390 to V7, is...
... 8.1.X, ... make ... looks like i spoke too soon (never happened before). not all have been upgraded, and i went to generate DDL, and got this: Query...
... found this on comp.databases.ibm-db2: Since some of the restrictions cover data types found in the DB2 catalog it basically rules out access to V7 from V8...
Has anyone else come up with a "run-time error '-2147024809 (80070057)' The parameter is incorrect." I get this since the last release of 6.1.5 when I try to...
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.
