Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Exporting Results from EDBManager
Wed, Nov 13 2013 9:43 PMPermanent Link

Adam H.

Hi,

I was wondering if there is a way to export the results of a query in
EDBManager please the same way that you can export from tables.
(Tasks-Export Table)?

Thanks & Regards

Adam.

(This may be a double up- I sent a post in previous, but it never showed
up)?
Thu, Nov 14 2013 4:21 AMPermanent Link

Uli Becker

Adam,

> I was wondering if there is a way to export the results of a query in
> EDBManager please the same way that you can export from tables.
> (Tasks-Export Table)?

You can create a (temporary) table to be able to export the result:

Create Table TempExport as
select * from MyTable
with data

Uli
Thu, Nov 14 2013 7:06 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam


>I was wondering if there is a way to export the results of a query in
>EDBManager please the same way that you can export from tables.
>(Tasks-Export Table)?

Don't think so. I just tried creating a temporary table and exporting that but no. All I can suggest is to create an in-memory (or disk) table, export that and then drop the table.

Roy Lambert [Team Elevate]
Thu, Nov 14 2013 7:51 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Uli


>You can create a (temporary) table to be able to export the result:
>
>Create Table TempExport as
>select * from MyTable
>with data


You are correct - I screwed up and missed out the TABLE keyword Frown

Roy
Thu, Nov 14 2013 4:20 PMPermanent Link

Adam H.

Hi Uli & Roy,

Thanks for that - I'll give that a try and see how it goes...

Best Regards

Adam.
Image