Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
EDB Manager SQL search results to a text editor instead of a result grid |
Sun, Aug 23 2009 10:47 AM | Permanent Link |
Mats Berggren | 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 |
Mon, Aug 24 2009 10:43 AM | Permanent Link |
Fernando Dias Team Elevate | 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] |
Mon, Aug 24 2009 11:11 AM | Permanent Link |
Brent | 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 |
Mon, Aug 24 2009 12:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |