Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
SaveToFile |
Sat, Feb 2 2008 9:47 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I know this has gone, but occasionally, as part of my development not when live, I want to save the result set down to disk to examine. What's the best way of doing this now-a-days? Roy Lambert |
Mon, Feb 4 2008 3:54 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I know this has gone, but occasionally, as part of my development not when live, I want to save the result set down to disk to examine. What's the best way of doing this now-a-days? >> CREATE TABLE AS is the best way. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Feb 6 2008 3:55 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< I know this has gone, but occasionally, as part of my development not >when live, I want to save the result set down to disk to examine. What's the >best way of doing this now-a-days? >> > >CREATE TABLE AS is the best way. My first reaction was "yeah OK, I should have thought of that" but something went CLONK in my head last night. Normally when I need to examine the contents of a query I just drop a grid and datasource onto the form and have a shuftie. Rarely, maybe one a year, I enter the WTF stage of debugging (might be output from a thread) and want to drop the result set to disk to examine. Unfortunately, CREATE TABLE AS cannot replicate the ORDER BY clause (yes I know I can set up an index which should be the same) and might require other changes to the sql, none of which, hopefully, should affect the result. So if there is an alternative I'd prefer it, if not then its rare and if I can't solve the problem (whatever it is) I'll just have to come sobbing to you for help. Roy Lambert |
Wed, Feb 6 2008 1:54 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Normally when I need to examine the contents of a query I just drop a grid and datasource onto the form and have a shuftie. Rarely, maybe one a year, I enter the WTF stage of debugging (might be output from a thread) and want to drop the result set to disk to examine. >> Maybe I'm missing something, but why not just run the query in the ElevateDB Manager and view the result set whenever/however you want ? -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Feb 7 2008 3:00 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
As I said its something I need to do rarely (one a year tops on average) and its a last resort when everything else I try indicates no problem. If I have a case arise where I need it I'll shout. Until then its best ignored. Roy Lambert |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |