export dataset does not work on grid filled with F5

Toad for Oracle
1

Enter a Select in Sql Editor.

Run script by pressing F5: you get a tab “Grid 1“ with a Grid on it.

Export this grid: right click, export dataset to a excel sheet: excel is empty.

Thanks,

Patrik

2

We haven’t been able to reproduce this, Patrik. Can you give us some
more details?

3

[ Attachment(s) from =?iso-8859-1?Q?B=F6schenstein_Patrik?= included below]

Weird.

Here my select statement:

select 1 , 2 , 3 , 4 from dual ;

I exported (the “Grid 1” on the “Script Output” tab!) to
a “Excel File” (see settings.jpg)

John, I get a Excel File and it opens, but it contains no data and no select
statement. Only one sheet called “Sheet2”. (see attachment)

Are you still not able to reproduce this?

Patrik

Von: toad@yahoogroups.com [mailto:toad@yahoogroups.com] Im Auftrag von John
Dorlon
Gesendet: Donnerstag, 22. Oktober 2009 21:37
An: toad@yahoogroups.com
Betreff: RE: [toad] export dataset does not work on grid filled with F5

We haven’t been able to reproduce this, Patrik. Can you give us some more
details?

4

I can reproduce this too, with another query. The problem is that the code is
executed with F5 and the data in Grid1 is not exportable. Maybe because the
export function is written for the standard grid that is bound to F9? And that
one has zero records. It is not there.

Patric, I would suggest for the time being use F9 for executing the query to a
better grid.
Groetjes,
Wim

On Fri, Oct 23, 2009 at 08:18, Böschenstein Patrik <
boeschenstein@infosystem.ch > wrote:

[ Attachment(s) from =?iso-8859-1?Q?B=F6schenstein_Patrik?= included below]

Weird.

Here my select statement:

 

select 1 , 2 , 3 , 4 from dual ;

 

I exported (the “Grid 1” on the “Script Output” tab!) to a “Excel
File” (see settings.jpg)

 

John, I get a Excel File and it opens, but it contains no data and no select
statement. Only one sheet called “Sheet2”. (see attachment)

 

Are you still not able to reproduce this?

 

Patrik

 

 

Von: toad@yahoogroups.com [mailto: toad@yahoogroups.com ] Im Auftrag von
John Dorlon
Gesendet: Donnerstag, 22. Oktober 2009 21:37
An: toad@yahoogroups.com
Betreff: RE: [toad] export dataset does not work on grid filled with F5

 

 

We haven’t been able to reproduce this, Patrik.    Can you give us some
more details?
5

Huh. Still can’t reproduce it.

It’s interesting that you only see “sheet2”. Makes me wonder
what happened to sheet1.

Will you send your toad.ini? Maybe some other setting is at play here.

6

[ Attachment(s) from Wim de Lange included below]

My toad.ini file as attachment
Groetjes,
Wim

On Fri, Oct 23, 2009 at 15:26, John Dorlon wrote:

Huh.  Still can’t reproduce it.

 

It’s interesting that you only see “sheet2”.  Makes me wonder what
happened to sheet1.

 

Will you send your toad.ini?  Maybe some other setting is at play here.
7

Still it works for me. Try this – shut down excel, then look in Task
Manager. Do you see an EXCEL.EXE still running? If so, kill it.

Other than that, I’m out of ideas.

-John

8

I can’t reproduce this either. However I never liked the way export
directly to excel worked. There have been some issues with the data. (i.e. not
in columns etc)

Try saving as tab delimited and exporting into excel.

Gene L. Bradley Jr.

Database Programmer/Analyst

Jackson State University

P.O. Box 17750

Jackson MS 39217

ph: 601.979.1042

fax: 601.371.9146

9

That’s troubling Gene, do you have some examples we can try to work through?

What version of Excel are you using, and do you try the Instance or the File exports?

10

Is it an internationalization thing? Since I am Swiss and Wim sounds European
too…

Jeff: I use Excel 2007.

John, I sent you my toad.ini offline, if you want to try.

Patrik

Von: toad@yahoogroups.com [mailto:toad@yahoogroups.com] Im Auftrag von John
Dorlon
Gesendet: Freitag, 23. Oktober 2009 17:10
An: toad@yahoogroups.com
Betreff: RE: [toad] export dataset does not work on grid filled with F5

Still it works for me. Try this – shut down excel, then look in Task
Manager. Do you see an EXCEL.EXE still running? If so, kill it.

Other than that, I’m out of ideas.

-John

11

Wim’s query was just a simple “select 1,2,3,4 from dual” so it
does not seem like an internationalization problem to me (no dates, decimals,
extended ascii or unicode characters).

12

I’m talking about Windows Settings.

Toad is a great product, but you guys are not very good in internationalization,
since after every new installation I have to change the paper layout from
“Letter” to “A4” :wink:

Von: toad@yahoogroups.com [mailto:toad@yahoogroups.com] Im Auftrag von John
Dorlon
Gesendet: Freitag, 23. Oktober 2009 17:35
An: toad@yahoogroups.com
Betreff: RE: [toad] export dataset does not work on grid filled with F5

Wim’s query was just a simple “select 1,2,3,4 from dual” so it
does not seem like an internationalization problem to me (no dates, decimals,
extended ascii or unicode characters).

13

Oh. I exported it as A4.

14

Patrik and Wim,

What version of Excel do you have? I have 2007 and can’t reproduce
it. Someone else in our office can reproduce it and he has Excel 2003.

-John

15

I have Excel 2007

Von: toad@yahoogroups.com [mailto:toad@yahoogroups.com] Im Auftrag von John
Dorlon
Gesendet: Freitag, 23. Oktober 2009 18:37
An: toad@yahoogroups.com
Betreff: RE: [toad] export dataset does not work on grid filled with F5

Patrik and Wim,

What version of Excel do you have? I have 2007 and can’t reproduce it.
Someone else in our office can reproduce it and he has Excel 2003.

-John

16

I’ve been using V10 from the inception and it was fine until i had to work all
day on my UK database.

SE and SB screens started to freeze every 5 minutes or so for about 30 seconds.
The freezing happens even when i view TOAD options

( i was trying to find out if i have wrong options checked).

What could be a problem?

It definitely not a database issue as i was monitoring it separately and there
were no waits from my TOAD connections.

17

Do you have the option checked to auto save Toad options every X minutes? What
about the option to backup editor contents every X minutes? If you are still in
a position to test, try disabling both of those options.

Michael

18

Maybe it is the Save Settings Every… option under General. What is that set
to?

Ed

[TeamT]

19

i disabled the second one. Where is the first one?

20

I use Excel 2007. But that is a stupid question. The XLS file is generated by
Toad and I as far as I know not by an application (not sure). The generated file
is 4096 bytes in size. Anyhow, not the case.

I’m Dutch, but I use American settings, but not for date formats.

Groetjes,
Wim

On Fri, Oct 23, 2009 at 18:37, John Dorlon wrote:

Patrik and Wim,

 

What version of Excel do you have?   I have 2007 and can’t reproduce
it.  Someone else in our office can reproduce it and he has Excel 2003.

 

-John