It would be really good if the export facility could remember the last set of columns, even within a session. It isn't easy to set up in the first place, having to do it again because you missed a column hurts.

--

Matthew Jones

Matthew Jones wrote:

> It would be really good if the export facility could remember the last set of columns, even within a session. It isn't easy to set up in the first place, having to do it again because you missed a column hurts.

Falls off chair as I discovered by accident that it uses SQL in the background. This should be an option from the dialog - skip the action, just generate the SQL for future use.

And how about putting in a SELECT option to make a query so I can do inner joins etc? And then just output all the columns somehow.

EXPORT TABLE "Export"
TO "CustomerAccount.csv"
IN STORE "Storage"
("AppGUID","ACCESSED","CreateDate","AccountEmail","AccountSettings","LastAccess","CreateDate","AccountAdminCreated")
FORMAT DELIMITED
ENCODING AUTO
DELIMITER CHAR #9
QUOTE CHAR '"'
DATE FORMAT 'yyyy-mm-dd'
TIME FORMAT 'hh:mm:ss n' AM LITERAL 'AM' PM LITERAL 'PM'
DECIMAL CHAR '.'
BOOLEAN TRUE LITERAL 'True' FALSE LITERAL 'False'
INCLUDE HEADERS
MAX ROWS -1


While I'm on, it would be good to have an "add all columns" option to the column selector, or at least remove already selected columns as you go. Easier to add all and remove a few than the current lots of clicks and forget which columns you've done already method.

--

Matthew Jones

Matthew Jones wrote:

> Falls off chair as I discovered by accident

It is worth saying that as usual, EDB has all the features one wants, it is just a matter of finding them when one is not a full time guru on it. I am not sure how this could be improved, other than by us as users whining and Tim adding things to make it more visible. 8-)

--

Matthew Jones

Matthew


EDBManager in most cases is just an sql front end. As with many applications it has a number of hidden / undocumented features some of which I've found and some been told about.

Here's one for you - Explorer | SQL History - the export statement used from the menu gets stuffed in there so you can copy / review / laugh about later.

Roy Lambert

Roy Lambert wrote:

> SQL History

Ah yes, you've mentioned that before, and it has been handy when I've been doing "SQL things". I think the big lesson here is that it is *all* SQL and so it is all worth digging into the underneath. Thank you.

--

Matthew Jones

Matthew,

<< Falls off chair as I discovered by accident that it uses SQL in the background. This should be an option from the dialog - skip the action, just generate the SQL for future use. >>

That's a good idea - added.

EWB's IDE is getting a bit of a "facelift" in 2.07, and the EDB Manager is next to get the same facelift.  When I do this, I'll be making some pretty significant improvements to how some of this works.

<< And how about putting in a SELECT option to make a query so I can do inner joins etc? And then just output all the columns somehow. >>

Not being able to export query results directly is a glaring hole in the EDB Manager functionality right now.  It will get patched up during the above-mentioned facelift.

<< While I'm on, it would be good to have an "add all columns" option to the column selector, or at least remove already selected columns as you go. Easier to add all and remove a few than the current lots of clicks and forget which columns you've done already method. >>

Noted.

Tim Young
Elevate Software
www.elevatesoft.com