Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread EDBMgr Feature Request
Mon, Apr 2 2012 12:35 PMPermanent Link

Alan Questell

Richmond Community College

Recently, I've been having to use EDBMgr *much* more than I've ever had to before...and here's two things that would really be nice, if you would kindly consider:

1. Quick menu on Table has "Empty Table" as an option.
2. When importing, the ability to save the state of the Customizations page, specifically the "Use Column Headers" check box. Although it's just a couple of clicks, I often forget, creating a mess...which takes me back to #1.
Thu, Apr 5 2012 1:19 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Alan,

<< 1. Quick menu on Table has "Empty Table" as an option. >>

This has been requested a few times, but I'm still holding off on it.  The
issue is that it is completely unrecoverable, so an end user could really
screw themselves by accidentally using this option, and we have a lot of end
users that use the EDB Manager.

<< 2. When importing, the ability to save the state of the Customizations
page, specifically the "Use Column Headers" check box. Although it's just a
couple of clicks, I often forget, creating a mess...which takes me back to
#1.  >>

No problem, I'll see what I can do.

--
Tim Young
Elevate Software
www.elevatesoft.com
Fri, Apr 6 2012 4:40 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Alan


Just in case Tim needs any support I'm with him on this. For a one-off table its not to difficult to click New and type EMPTY TABLE FRED and hit F9.

Also if you have a lot of them to empty:

1. Make sure no one is using them
2, Use Windows Explorer to delete the table files

It works because all the metatdata is now in the catalog. I used it via Delphi and ShellExecute before Tim gave us EMPTY TABLE because DELETE FROM was to slooooow

Roy Lambert [Team Elevate]
Fri, Apr 6 2012 1:09 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< It works because all the metatdata is now in the catalog. I used it via
Delphi and ShellExecute before Tim gave us EMPTY TABLE because DELETE FROM
was to slooooow >>

DELETE FROM is *extremely* fast in EDB.  In fact, it's the fastest type of
write operation that you can do.  You might have been getting tripped up by
extensive text indexes, or just a lot of indexes in general.  That might
have slowed things down a bit.

--
Tim Young
Elevate Software
www.elevatesoft.com
Fri, Apr 6 2012 1:36 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

><< It works because all the metatdata is now in the catalog. I used it via
>Delphi and ShellExecute before Tim gave us EMPTY TABLE because DELETE FROM
>was to slooooow >>
>
>DELETE FROM is *extremely* fast in EDB. In fact, it's the fastest type of
>write operation that you can do. You might have been getting tripped up by
>extensive text indexes, or just a lot of indexes in general. That might
>have slowed things down a bit.

Could be, but "off to the recycling bin with you" is even faster Smiley

Roy Lambert
Image