Hi,

I have a short question about the EDB Manager (Version 2.02 Build 15).
Is it possible to get the result of a SQL-query to a simple text editor instead of to a result grid?
Sometimes it is useful to use SQL to produce results in text form so they can be easily included in documents.

Regards,
Mats Berggren

Mats,

You can create a temporary table containing the result set of your query and
then export it to a text file, but I suspect that's not exactly what you are
looking for...
Anyway, you can do a test and see if it suits your needs:

Creating the table:
  CREATE TEMPORARY TABLE "TempResult"
  AS
  <Your Query Expression>
  WITH DATA


Then export the table:
  EXPORT TABLE "TempResult"
  TO <FileName>
  IN STORE <StoreName>


References:

Temporary tables:
http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=10&topic=148

Exporting tables:
http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=14&topic=288


--
Fernando Dias
[Team Elevate]

Mats

I have used another db Mgr for another database and they have a terrific option where you
can toggle the query results to text just by pressing Ctrl-L.  Normally the query results
are displayed to a grid, but pressing Ctrl-L turns the grid output into columnar text
complete with column headings etc. using a fixed spaced font in less than a second in the
same screen area that the grid used to be (the text pane replaces the grid pane). I can
now copy and paste any or all of the results to a text editor or do a Ctrl-F (Find) on the
text. To change it back to a grid just press Ctrl-L again. This has saved me a great deal
of time and effort. It also works on any type of query, not just select statements. If Tim
could implement this it would be very cool.

Brent

Brent,

<< I have used another db Mgr for another database and they have a terrific
option where you can toggle the query results to text just by pressing
Ctrl-L.  Normally the query results are displayed to a grid, but pressing
Ctrl-L turns the grid output into columnar text complete with column
headings etc. using a fixed spaced font in less than a second in the same
screen area that the grid used to be (the text pane replaces the grid pane).
I can now copy and paste any or all of the results to a text editor or do a
Ctrl-F (Find) on the text. To change it back to a grid just press Ctrl-L
again. This has saved me a great deal of time and effort. It also works on
any type of query, not just select statements. If Tim could implement this
it would be very cool. >>

I'll see what I can do.

--
Tim Young
Elevate Software
www.elevatesoft.com