Can a second option be provided that would open a SQL editor of
choice?  Currently it says "Note: for technical reasons, only Notepad
can be used."  The current option cannot be changed at this time.

This choice could be linked to the Edit\Edit using SQL editor (CTRL+E)
bring in a color text editor or any other program.


Another observation - during the GUI Query builder, I see that BOTH
SQL(index tab) and AQT option (menu) are available.  Is there any way
the SQL options could be available when using the SQL window (not in
the GUI builder)?  This can be useful in the load query, edit/modify
it via the GUI interface that have a particular join format.  If it is
wrong initially, the GUI interface doesn't join properly - and
requires user to change to the correct option, reload query, and try
again.  An interface that can be handy is one recognizing a potential
SQL problem and present the user the SQL option to correct it (some
frequent ones are for joins and column naming (ex: select col1 as
Column1 from datatable is handled correctly, where select col1 Column1
from datatable puts ": Column1" into the function column).  In the
column naming, it could loop with user intervention to better
distinguish function and column name operations.  Once the SQL query
is cleaned up, I find the final AQT enhanced query more clearly
defined, robust, and 'formatted' to take advantage of AQT's useful
features in ways other tools cannot.

Keep the great enhancements coming and look forward to participating here!
Todd

And great to have someone cares enough to support the tools we use!  Thanks
for all the help you have given Phil.

Sandra

-----Original Message-----
From: Theophan [mailto:theophan@...]
Sent: Sunday, 30 June 2002 01:20
To: aqt@yahoogroups.com
Subject: Re: [aqt] AQT Version 5.1.2 Released


It's GREAT to have a product that is BOTH updated frequently AND has an
elegant and efficient user interface.

Great job Phil!
I expect to make extensive use of the Batching capability and the SQLBase
outer join syntax clears the way.

_theophan

> Hi there,
> just to let you know that I have uploaded the latest point-release of AQT.
This has a number of bug fixes and minor enhancements.
>
> The changes are:
>
> bug fixes
> =========
> .      some functions in the GUI Query Builder failed when there were more
than 10 tables in the query.
> .      GO as a statement delimiter was not working for Sybase
>       Outer Join syntax is now generated correctly for SQLBase
> .      Run Stored Procedures for Sybase should be more reliable (we've
improved the work-arounds for problems with some ODBC drivers).
> .      Can now deal with Stored Procedure Input and Output parameters of
up to 5000 bytes in size.
>
> New functions
> =============
> .      a new window has been added to display the results of Compare
Results
> .      Batch Mode operation of AQT has been added
>
> Phil.
>
>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=225001.2174133.3620975.1971030/D=egroupweb/S=17050071
83:HM/A=1044509/R=0/*http://www.gotomypc.com/u/tr/yh/grp/300_1b/g22lp?Target
=mm/g22lp.tmpl> Click Here!

To unsubscribe from this group, send an email to:
aqt-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

hadn't realized it was different, NT to 390.  just downloaded the 29
june drop.  now in sequence order.

you da man.

toodles,
robert

--- In aqt@y..., "cardettnz" <group@c...> wrote:
> I presume you are talking about DB2/390, and the display "Columns
in Index".
>
> This is easy. I should have set it up like this in the first place.
You can change it yourself by finding file db2390.cfg and changing
line 215 (which starts with "47;m;Columns in index") to have "Order
by 2" instead of "Order by 1". I'll make this change with the next
release.
>
> Phil.
>
> --- In aqt@y..., "ryoungbugs" <ryoung27@c...> wrote:
> > would be helpful, since i've inherited databases which have
indexes
> > with LOTS of columns, to be able to sort the display on Seq.
> >
> > thanks.
> > robert

It's GREAT to have a product that is BOTH updated frequently AND has an elegant
and efficient user interface.

Great job Phil!
I expect to make extensive use of the Batching capability and the SQLBase outer
join syntax clears the way.

_theophan

> Hi there,
> just to let you know that I have uploaded the latest point-release of AQT.
This has a number of bug fixes and minor enhancements.
>
> The changes are:
>
> bug fixes
> =========
> . some functions in the GUI Query Builder failed when there were more than 10
tables in the query.
> . GO as a statement delimiter was not working for Sybase
>  Outer Join syntax is now generated correctly for SQLBase
> . Run Stored Procedures for Sybase should be more reliable (we've improved the
work-arounds for problems with some ODBC drivers).
> . Can now deal with Stored Procedure Input and Output parameters of up to 5000
bytes in size.
>
> New functions
> =============
> . a new window has been added to display the results of Compare Results
> . Batch Mode operation of AQT has been added
>
> Phil.
>
>

Hi there,
just to let you know that I have uploaded the latest point-release of AQT. This
has a number of bug fixes and minor enhancements.

The changes are:

bug fixes
=========
. some functions in the GUI Query Builder failed when there were more than 10
tables in the query.
. GO as a statement delimiter was not working for Sybase
	 Outer Join syntax is now generated correctly for SQLBase
. Run Stored Procedures for Sybase should be more reliable (we've improved the
work-arounds for problems with some ODBC drivers).
. Can now deal with Stored Procedure Input and Output parameters of up to 5000
bytes in size.

New functions
=============
. a new window has been added to display the results of Compare Results
. Batch Mode operation of AQT has been added

Phil.

I presume you are talking about DB2/390, and the display "Columns in Index".

This is easy. I should have set it up like this in the first place. You can
change it yourself by finding file db2390.cfg and changing line 215 (which
starts with "47;m;Columns in index") to have "Order by 2" instead of "Order by
1". I'll make this change with the next release.

Phil.

--- In aqt@y..., "ryoungbugs" <ryoung27@c...> wrote:
> would be helpful, since i've inherited databases which have indexes
> with LOTS of columns, to be able to sort the display on Seq.
>
> thanks.
> robert

ahah, so Hot_Insites is a real AQT person. With a name like that I thought you
were a spammer (a problem with Forums) and you almost got  removed.

Sourceedit looks very good. I use a similar tool EditPlus on a daily basis and
find the syntax-highlighting very good. This will undoubtably be a useful
addition to AQT. I started work on it a while ago - I naively thought you'd be
able to buy a control which did it for you. Or at least down-load some
good-quality sample code. But none of these were the case - I had to code it all
by hand. A big job to do, and one which I will return to at some point.


Phil.


--- In aqt@y..., "Hot_Insites" <insights4u@y...> wrote:
> I find this useful -
>
> Download - Source Edit a free editor which supports a variety of
> languages.  It may spark some ideas for AQT with a particular focus on
> recognizing and colorizing the standard SQL-92 syntax.  On the other
> hand you may find it useful to use both? and a future AQT release
> perhaps can learn to work/interact with this application and Phil/AQT
> can focus on functional improvements to AQT.
>
> Todd
>
> http://www.sourceedit.cc/
>
> What is it?
> Source Edit is an editor especially made for developers but can of
> cource be used as a regular text editor as well. It natively supports
> the following languages.
>
> ASP
> PHP
> Java
> C/C++
> C#
> Visual Basic
> Pascal
> Perl
> Cold Fusion
> SQL
> HTML
> CSS
> XML
>
> Source Edit quickly and seamlessly colors all code written in any of
> these languages. Do you miss a language? Check the Tips & Resource
> page for more language highlighters. You can also create a new one
> yourself using the Language Editor.
>
>
> --- In aqt@y..., "cardettnz" <group@c...> wrote:
> > No, there is no way of changing the font color. And, as you have
> noticed, any changes to the font size/type apply to the entire
> text-box. Both these limitations are due to the type of Control we use
> here - a "text-box" as opposed to a "rich text-box".
> > I may change this at some time in the future (I have been toying
> with syntax-highlighting of SQL, but this is quite a lot of work to
> program so it has been temporarily shelved). Probably not this year
> though.
> >
> > Phil.
> >
> >
> >
> > --- In aqt@y..., "delwork7" <delwork7@y...> wrote:
> > > Is there a way to change color of the text I write into queries at
> > > the'Run SQL' screen? For example, at the 'Run SQL' screen, I make a
> > > lot of tweaks and it would be nice if my writing was a different
> > > color so it could be found easily. In a long query, it's usually my
> > > edit that goes wrong and in a complex query it would be a quick find
> > > to get where you were editing. I see that you can change the font,
> > > but it changes all the font. This would just be the font or color
> > > that I type or double click in from the expressions below in the
> > > boxes.

would be helpful, since i've inherited databases which have indexes
with LOTS of columns, to be able to sort the display on Seq.

thanks.
robert

Focusing on a solution (rather than product loyalty), you could always paste the
query into the free version of WINSQL which automatically color codes Sql
statements (but it can't hold a candle to AQT's capabilities.)

_theophan

> I find this useful -
>
> Download - Source Edit a free editor which supports a variety of
> languages.  It may spark some ideas for AQT with a particular focus on
> recognizing and colorizing the standard SQL-92 syntax.  On the other
> hand you may find it useful to use both? and a future AQT release
> perhaps can learn to work/interact with this application and Phil/AQT
> can focus on functional improvements to AQT.
>
> Todd
>
> http://www.sourceedit.cc/
>
> What is it?
> Source Edit is an editor especially made for developers but can of
> cource be used as a regular text editor as well. It natively supports
> the following languages.
>
> ASP
> PHP
> Java
> C/C++
> C#
> Visual Basic
> Pascal
> Perl
> Cold Fusion
> SQL
> HTML
> CSS
> XML
>
> Source Edit quickly and seamlessly colors all code written in any of
> these languages. Do you miss a language? Check the Tips & Resource
> page for more language highlighters. You can also create a new one
> yourself using the Language Editor.
>
>
> --- In aqt@y..., "cardettnz" <group@c...> wrote:
> > No, there is no way of changing the font color. And, as you have
> noticed, any changes to the font size/type apply to the entire
> text-box. Both these limitations are due to the type of Control we use
> here - a "text-box" as opposed to a "rich text-box".
> > I may change this at some time in the future (I have been toying
> with syntax-highlighting of SQL, but this is quite a lot of work to
> program so it has been temporarily shelved). Probably not this year
> though.
> >
> > Phil.
> >
> >
> >
> > --- In aqt@y..., "delwork7" <delwork7@y...> wrote:
> > > Is there a way to change color of the text I write into queries at
> > > the'Run SQL' screen? For example, at the 'Run SQL' screen, I make a
> > > lot of tweaks and it would be nice if my writing was a different
> > > color so it could be found easily. In a long query, it's usually my
> > > edit that goes wrong and in a complex query it would be a quick find
> > > to get where you were editing. I see that you can change the font,
> > > but it changes all the font. This would just be the font or color
> > > that I type or double click in from the expressions below in the
> > > boxes.
>
>
>
> To unsubscribe from this group, send an email to:
> aqt-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

I find this useful -

Download - Source Edit a free editor which supports a variety of
languages.  It may spark some ideas for AQT with a particular focus on
recognizing and colorizing the standard SQL-92 syntax.  On the other
hand you may find it useful to use both? and a future AQT release
perhaps can learn to work/interact with this application and Phil/AQT
can focus on functional improvements to AQT.

Todd

http://www.sourceedit.cc/

What is it?
Source Edit is an editor especially made for developers but can of
cource be used as a regular text editor as well. It natively supports
the following languages.

ASP
PHP
Java
C/C++
C#
Visual Basic
Pascal
Perl
Cold Fusion
SQL
HTML
CSS
XML

Source Edit quickly and seamlessly colors all code written in any of
these languages. Do you miss a language? Check the Tips & Resource
page for more language highlighters. You can also create a new one
yourself using the Language Editor.


--- In aqt@y..., "cardettnz" <group@c...> wrote:
> No, there is no way of changing the font color. And, as you have
noticed, any changes to the font size/type apply to the entire
text-box. Both these limitations are due to the type of Control we use
here - a "text-box" as opposed to a "rich text-box".
> I may change this at some time in the future (I have been toying
with syntax-highlighting of SQL, but this is quite a lot of work to
program so it has been temporarily shelved). Probably not this year
though.
>
> Phil.
>
>
>
> --- In aqt@y..., "delwork7" <delwork7@y...> wrote:
> > Is there a way to change color of the text I write into queries at
> > the'Run SQL' screen? For example, at the 'Run SQL' screen, I make a
> > lot of tweaks and it would be nice if my writing was a different
> > color so it could be found easily. In a long query, it's usually my
> > edit that goes wrong and in a complex query it would be a quick find
> > to get where you were editing. I see that you can change the font,
> > but it changes all the font. This would just be the font or color
> > that I type or double click in from the expressions below in the
> > boxes.

No, there is no way of changing the font color. And, as you have noticed, any
changes to the font size/type apply to the entire text-box. Both these
limitations are due to the type of Control we use here - a "text-box" as opposed
to a "rich text-box".
I may change this at some time in the future (I have been toying with
syntax-highlighting of SQL, but this is quite a lot of work to program so it has
been temporarily shelved). Probably not this year though.

Phil.



--- In aqt@y..., "delwork7" <delwork7@y...> wrote:
> Is there a way to change color of the text I write into queries at
> the'Run SQL' screen? For example, at the 'Run SQL' screen, I make a
> lot of tweaks and it would be nice if my writing was a different
> color so it could be found easily. In a long query, it's usually my
> edit that goes wrong and in a complex query it would be a quick find
> to get where you were editing. I see that you can change the font,
> but it changes all the font. This would just be the font or color
> that I type or double click in from the expressions below in the
> boxes.

I don't know of a way using AQT but here's what I do.  I keep all my longer
queries, and queries I may reuse in a Word document. (where I also keep
supporting details and explanations).

Paste the base query from the 'Run  SQL' screen into your Word document,
make your changes in Word, using different fonts, colours etc then paste the
query back into AQT.

Some really big or particularly specialised queries go into their own
documents but I have one document I keep all everyday queries in.  In the
long run I make fewer errors this way as if I am using techniques I use only
rarely I just need to check in the document for how I did it last time.

For my daily SQL document I use the online layout view in Word 97 and use
the various levels of "heading" style text in my document so the outline
pane provides a handy index but I still can see all my formatting in the
page layout pane.

Sandra

-----Original Message-----
From: delwork7 [mailto:delwork7@...]
Sent: Wednesday, 26 June 2002 06:02
To: aqt@yahoogroups.com
Subject: [aqt] Font_Color


Is there a way to change color of the text I write into queries at
the'Run SQL' screen? For example, at the 'Run SQL' screen, I make a
lot of tweaks and it would be nice if my writing was a different
color so it could be found easily. In a long query, it's usually my
edit that goes wrong and in a complex query it would be a quick find
to get where you were editing. I see that you can change the font,
but it changes all the font. This would just be the font or color
that I type or double click in from the expressions below in the
boxes.



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=178320.2150041.3600347.1829184/D=egroupweb/S=17050071
83:HM/A=979988/R=0/*http://www.fastweb.com/ib/yahoo-79f>

<http://us.adserver.yahoo.com/l?M=178320.2150041.3600347.1829184/D=egroupmai
l/S=1705007183:HM/A=979988/rand=813461384>

To unsubscribe from this group, send an email to:
aqt-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

Is there a way to change color of the text I write into queries at
the'Run SQL' screen? For example, at the 'Run SQL' screen, I make a
lot of tweaks and it would be nice if my writing was a different
color so it could be found easily. In a long query, it's usually my
edit that goes wrong and in a complex query it would be a quick find
to get where you were editing. I see that you can change the font,
but it changes all the font. This would just be the font or color
that I type or double click in from the expressions below in the
boxes.

Hi all

This is my Newbie post to introduce myself to the group .

I am Sandra Monk, Senior Business Analyst at Skill New Zealand.- I am new to
the group but not AQT (or egroups).

We have 9 licences to AQT and have been using it since early 2000 - v2.4.
We use AQT to support a Sybase ASE database.

regards
Sandra
______________________________________
Sandra Monk
Senior Business Analyst
Information Systems
Skill New Zealand - Pukenga Aotearoa
P O Box 27048
Wellington
New Zealand
Ph +64 4 382 2868  Fax +64 4 801 5598
E-mail:  sandra.monk@...
www.skillnz.govt.nz
_______________________________________
This E-mail is only intended to be read by the named recipient.  It may
contain information which is confidential, proprietary or the subject of
legal privilege.  If you are not the intended recipient you must delete this
E-mail and may not use any information contained in it.  Legal privilege is
not waived because you have read this E-mail.
_______________________________________

SQLBase does indeed use the same "non-intuitive" designations.  I think of the
relationship as adding(+) null values to the column that may NOT have rows.  I'm
not sure of the limitations of other RDBS's but SQLBASE will only allow (1)
outer join per select statement - although that join CAN contain multiple
columns.    I end up using alot of views, sub-selects and exists to get what I
what.

Will keep an eye out for the release - THANKS!

_theophan

> The join problem can be eaily fixed. I'll put it into V5.1.2, due to be
released in a few
> days time. I currently generate joins in this format for Oracle - I'll just do
the same for
> SQLBase. A couple of lines of code.
>
> In GUI, in Options->Join Syntax you will see options for the syntax to be used
for joins.
> You won't see anything here now, but in V5.1.2 you will see options appearing
here.
>
> However, one issue we need to sort out. In Oracle, a left outer join is:
> tab1=tab2(+)
> and a right outer join is:
> tab1(+)=tab2
> Yes I know this is non-intuitive, and I had it wrong in earlier releases of
AQT. However
> this is indeed the case.
>
> Can you confirm for me whether, for SQLBase, tab1=tab2(+) is a left or right
join?
>
> Thanks,
> Phil.
>
>
> > 5.x is a GREAT Product. The more I use it the more I like it and as
> > soon as I get to playing with scripts it will replace my SQLTalk but
> > I have one problem:
> >
> > When using the Query Builder and adding an Outer Join I keep getting
> > a "Command not properly ended". If I copy to Run_SQL the query text
> > has a different format than my usual way of writing my joins under
> > SQLBase. Example Follows:
> >
> > AQT:
> > "left outer join sysadm.rma R on C1.id=R.new_cust_order_id"
> >
> > If changed in Run SQL to:
> > , sysadm.rma R where C1.id(+) = R.new_cust_order_id
> >
> > The query works and transfers to BUILDER as an RIGHT Outer Join but
> > will give the previous error when attempting to run.
> >
> > Is there a workaround?
> >
> >
> >

The join problem can be eaily fixed. I'll put it into V5.1.2, due to be released
in a few
days time. I currently generate joins in this format for Oracle - I'll just do
the same for
SQLBase. A couple of lines of code.

In GUI, in Options->Join Syntax you will see options for the syntax to be used
for joins.
You won't see anything here now, but in V5.1.2 you will see options appearing
here.

However, one issue we need to sort out. In Oracle, a left outer join is:
tab1=tab2(+)
and a right outer join is:
tab1(+)=tab2
Yes I know this is non-intuitive, and I had it wrong in earlier releases of AQT.
However
this is indeed the case.

Can you confirm for me whether, for SQLBase, tab1=tab2(+) is a left or right
join?

Thanks,
Phil.


> 5.x is a GREAT Product. The more I use it the more I like it and as
> soon as I get to playing with scripts it will replace my SQLTalk but
> I have one problem:
>
> When using the Query Builder and adding an Outer Join I keep getting
> a "Command not properly ended". If I copy to Run_SQL the query text
> has a different format than my usual way of writing my joins under
> SQLBase. Example Follows:
>
> AQT:
> "left outer join sysadm.rma R on C1.id=R.new_cust_order_id"
>
> If changed in Run SQL to:
> , sysadm.rma R where C1.id(+) = R.new_cust_order_id
>
> The query works and transfers to BUILDER as an RIGHT Outer Join but
> will give the previous error when attempting to run.
>
> Is there a workaround?
>
>
>
> To unsubscribe from this group, send an email to:
> aqt-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

5.x is a GREAT Product.  The more I use it the more I like it and as
soon as I get to playing with scripts it will replace my SQLTalk but
I have one problem:

When using the Query Builder and adding an Outer Join I keep getting
a "Command not properly ended".  If I copy to Run_SQL the query text
has a different format than my usual way of writing my joins under
SQLBase.  Example Follows:

AQT:
"left outer join sysadm.rma R on C1.id=R.new_cust_order_id"

If changed in Run SQL to:
, sysadm.rma R where C1.id(+) = R.new_cust_order_id

The query works and transfers to BUILDER as an RIGHT Outer Join but
will give the previous error when attempting to run.

Is there a workaround?

Remember userid-password. I am exploring various approaches to this:

a) startup-script. With this idea one can specify a script to run when AQT is
started.
This script will have a bunch of Connect statements. The idea here is that when
you
start AQT it will automatically connect you to the 10 databases you commonly
deal with
- saves a lot of time establishing one's environment.

b) database-info. I plan on allowing AQT to hold options on particular
databases. One of
these will be to remember the userid and/or password. Other parameters will be
whether to allow or warn-for updates/deletes/drops. The idea here is that you
can set up
a user (or yourself) to have free-reign access to a dev database, but be warned
(or
disallowed) when you run an update against your prod database. As a DBA I am
constantly worried about doing an update/drop against a prod database when I
think I
am using the dev database. This feature will help prevent this.

For the password-remember to work, I will need to hold it in an encrypted form
(I need
to check out encryption algorithms).

I hope to implement some of these ideas this year.

Phil.

> it was the Edit/Set Font list box from the Query Result, but it seems
> OK since the 8 june update.
>
> also (sorry), but is there a way for AQT to remember the
> userid/password by database? in 5.0.x, the DB2/390 connections
> remembered if i clicked on the database name in the list box; UDB
> databases didn't. now, it seems, none do.
>
> on the whole, quite happy with AQT.
>
> toodles,
> robert
>
>
> --- In aqt@y..., "Phil Castle" <group@c...> wrote:
> > actually the font is (sort-of) remembered (there was a minor
> bugette which I've
> > corrected).
> >
> > What list-box comes up in Sans Serif? The ones I have checked out
> seem to have the
> > correct font. There are dozens of listboxes - not sure which one
> you are referring to.
> >
> > Phil.
> >
> >
> >
> > > a couple of things have gone:
> > >
> > > - font is no longer remembered, and the list box always comes up
> in
> > > Sans Serif, ugh
> > >
> > > - the last menu has no hot key for File, or its list items.
> > >
> > > robert
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > aqt-unsubscribe@y...
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> To unsubscribe from this group, send an email to:
> aqt-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

it was the Edit/Set Font list box from the Query Result, but it seems
OK since the 8 june update.

also (sorry), but is there a way for AQT to remember the
userid/password by database?  in 5.0.x, the DB2/390 connections
remembered if i clicked on the database name in the list box; UDB
databases didn't.  now, it seems, none do.

on the whole, quite happy with AQT.

toodles,
robert


--- In aqt@y..., "Phil Castle" <group@c...> wrote:
> actually the font is (sort-of) remembered (there was a minor
bugette which I've
> corrected).
>
> What list-box comes up in Sans Serif? The ones I have checked out
seem to have the
> correct font. There are dozens of listboxes - not sure which one
you are referring to.
>
> Phil.
>
>
>
> > a couple of things have gone:
> >
> > - font is no longer remembered, and the list box always comes up
in
> > Sans Serif, ugh
> >
> > - the last menu has no hot key for File, or its list items.
> >
> > robert
> >
> >
> > To unsubscribe from this group, send an email to:
> > aqt-unsubscribe@y...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.

actually the font is (sort-of) remembered (there was a minor bugette which I've
corrected).

What list-box comes up in Sans Serif? The ones I have checked out seem to have
the
correct font. There are dozens of listboxes - not sure which one you are
referring to.

Phil.



> a couple of things have gone:
>
> - font is no longer remembered, and the list box always comes up in
> Sans Serif, ugh
>
> - the last menu has no hot key for File, or its list items.
>
> robert
>
>
> To unsubscribe from this group, send an email to:
> aqt-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

It works now.
   cardettnz <group@...> wrote: This can be downloaded from
http://www.querytool.com/download.html.

This has a number of major new features:
- ability to be connected to more than one database
- ability to have multiple result windows open
- plus many other new features. This release is the result of many
months of work and satisfies a large number of requirements we have
received from our users.

All V4 users get a free upgrade to V5 (your V4 reg key will work with
this new release).

Enjoy!

Phil Castle.


Yahoo! Groups SponsorADVERTISEMENT

To unsubscribe from this group, send an email to:
aqt-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup

[Non-text portions of this message have been removed]

This address http://www.querytool.com/download.html. takes you to a blank
screen.

   cardettnz <group@...> wrote: This can be downloaded from
http://www.querytool.com/download.html.

This has a number of major new features:
- ability to be connected to more than one database
- ability to have multiple result windows open
- plus many other new features. This release is the result of many
months of work and satisfies a large number of requirements we have
received from our users.

All V4 users get a free upgrade to V5 (your V4 reg key will work with
this new release).

Enjoy!

Phil Castle.


Yahoo! Groups SponsorADVERTISEMENT

To unsubscribe from this group, send an email to:
aqt-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup

[Non-text portions of this message have been removed]

Thanks,
will fix these issues in V5.1.2, which I will release within a week or so.

Phil.


> a couple of things have gone:
>
> - font is no longer remembered, and the list box always comes up in
> Sans Serif, ugh
>
> - the last menu has no hot key for File, or its list items.
>
> robert
>
>
> To unsubscribe from this group, send an email to:
> aqt-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

a couple of things have gone:

- font is no longer remembered, and the list box always comes up in
Sans Serif, ugh

- the last menu has no hot key for File, or its list items.

robert

The favorite idea would work. Thanks.

--- In aqt@y..., "cardettnz" <group@c...> wrote:
> Can you tell me what type of database you are using?
>
> If you are using SQL Server or Sybase (as I suspect) then it is
> difficult to filter-out system tables. What you are probably seeing
> are a bunch of system-tables that are identified as being user-
> tables. Not much I can do about this - speak to MS.
>
> What you are probably wanting is some type of "favourites" idea -
> where you can specify a list of tables you deal with frequently. A
> few other people have asked for this too. I may add this feature at
> some stage - not sure when exactly.
>
> Phil C
>
> --- In aqt@y..., "delwork7" <delwork7@y...> wrote:
> > When bringing up the tables in AQT, I use the system tables in
> order
> > to get the correct order in the ddl function. But in the
> main "table"
> > screen I get a whole bunch of system tables and other tables I
> never
> > use in a query. I understand there is a filter in the upper box
to
> > just show those tables with the typed in pattern. Is there a way
to
> > tell AQT to only show at the main screen those tables I use and
> > filter out the ones I don't. Not all the tables I use have the
same
> > pattern so the filter doesn't help.

This can be downloaded from http://www.querytool.com/download.html.

This has a number of major new features:
- ability to be connected to more than one database
- ability to have multiple result windows open
- plus many other new features. This release is the result of many
months of work and satisfies a large number of requirements we have
received from our users.

All V4 users get a free upgrade to V5 (your V4 reg key will work with
this new release).

Enjoy!

Phil Castle.

Can you tell me what type of database you are using?

If you are using SQL Server or Sybase (as I suspect) then it is
difficult to filter-out system tables. What you are probably seeing
are a bunch of system-tables that are identified as being user-
tables. Not much I can do about this - speak to MS.

What you are probably wanting is some type of "favourites" idea -
where you can specify a list of tables you deal with frequently. A
few other people have asked for this too. I may add this feature at
some stage - not sure when exactly.

Phil C

--- In aqt@y..., "delwork7" <delwork7@y...> wrote:
> When bringing up the tables in AQT, I use the system tables in
order
> to get the correct order in the ddl function. But in the
main "table"
> screen I get a whole bunch of system tables and other tables I
never
> use in a query. I understand there is a filter in the upper box to
> just show those tables with the typed in pattern. Is there a way to
> tell AQT to only show at the main screen those tables I use and
> filter out the ones I don't. Not all the tables I use have the same
> pattern so the filter doesn't help.

When bringing up the tables in AQT, I use the system tables in order
to get the correct order in the ddl function. But in the main "table"
screen I get a whole bunch of system tables and other tables I never
use in a query. I understand there is a filter in the upper box to
just show those tables with the typed in pattern. Is there a way to
tell AQT to only show at the main screen those tables I use and
filter out the ones I don't. Not all the tables I use have the same
pattern so the filter doesn't help.

This is indeed possible. Just select the text then hit run (or F5). If you have
selected any text, AQT will just run what you have selected. Otherwise, it will
run all the text.

Phil Castle.


--- In aqt@y..., "dipikari" <dipikari@g...> wrote:
> Hello
> it would be very nice if it would be possible not only to run the
> complete SQL-commands but only the marked text.
>
> Dirk

Hello
it would be very nice if it would be possible not only to run the
complete SQL-commands but only the marked text.

Dirk