Toad World® Forums

Export wizard


#1
  1. When setting objects to export I chose query.

Its very common habit, then if I put a cursor in query area previous [default]
text disappears.
But not here ;(

Severity: minor

  1. As a query I entered select … for XML statement. And I have no applicable
    output format to gain results!
    Most similar [XML data] causes wrapping result into default node set.

severity: Critical!


Butter

int_1.jpeg
int_1.jpeg


#2

Motyl, you are doing excellent work … This is just another good catch !!!

I do not do anything with XML, because I am working with a large amount of data,
so it is good that you are finding these issues. YEAH!!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image002.jpeg


#3

Motyl, you are doing excellent work … This is just another good catch !!!

I do not do anything with XML, because I am working with a large amount of data,
so it is good that you are finding these issues. YEAH!!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image001.gif


#4

Motyl, you are doing excellent work … This is just another good catch !!!

I do not do anything with XML, because I am working with a large amount of data,
so it is good that you are finding these issues. YEAH!!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
int_1.jpeg


#5

Motyl, you are doing excellent work … This is just another good catch !!!

thanks.

I do not do anything with XML, because I am working with a large amount of data,
so it is good that you are finding these issues. YEAH!!!
[…]

I’m also more play with recordsets then with with xml but sometimes it is more
convenient to use xml for data exchange.


Butter


#6

Hello Marcin,

I have some questions :
image002.jpeg


#7

Hello Marcin,

I have some questions :
image001.gif


#8

Hello Marcin,

I have some questions :
image001.jpeg


#9

Hello Marcin,

I have some questions :
image001.jpeg


#10

Hello Marcin,

I have some questions :
int_1.jpeg


#11

[ Attachment(s) from Motyl Marcin included below]

Hello Marcin,

I have some questions :

  1. Its very common habit, then if I put a cursor in query area previous
    [default] text disappears.

Do you type query manual or select file with query?

Once I copied if from clipboard. other times typed directly

And what you do next, before you see that text disappears?

problem is that I have to ‘disappear’ this text - I’m talking about ‘please
input a single…’

I talked, that if [in other applications] I put a cursor in such area and start
typing, default [welcome] text

disappears. But in this window I have to remember to mark and delete whole
previous text.

Could you please show your script you use in query?

I was test on. Something like ‘select top 10 col_c [@attr1], col_2[@attr2], text
from table for xml path(‘elem’), root(‘root’)’

  1. As a query I entered select … for XML statement. And I have no applicable
    output format to gain results!

What kind of format do you want to use for xml data? Do you see all following
formats in drop-down list:

I do not understand your question clearly. See attached sql [it contains data
and query as well]

I expect I will be able to export it to XML file. None of format below do not
allow me to gain this.

I’ve also attached how expected output should look like.

Comma Separated Values

Fixed Column Width

Tab Delimited Text

Delimited Text

XML Data

Html table

SQL Script

Access Database File

Create As New Table

Excel

?

[…]

  1. When setting objects to export I chose query.

Its very common habit, then if I put a cursor in query area previous [default]
text disappears.

But not here ;(

Severity: minor

  1. As a query I entered select … for XML statement. And I have no applicable
    output format to gain results!

Most similar [XML data] causes wrapping result into default node set.

severity: Critical!

Pozdrowienia,

Motyl Marcin
int_1.jpeg