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

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

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

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

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