Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 16 total
Thread Droping all the table
Sun, Sep 27 2009 1:31 PMPermanent Link

"Sorin H"
Hello

If the option to drop all the tables from a database doesn't exists it can
be a helpful function
If it exists how?

Thanks Sorin



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4462 (20090927) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



Sun, Sep 27 2009 1:33 PMPermanent Link

"Sorin H"
From the elevatedb manager I mean



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4462 (20090927) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



Mon, Sep 28 2009 2:30 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Sorin


Use DROP DATABASE ....

Roy Lambert [Team Elevate]
Mon, Sep 28 2009 4:23 AMPermanent Link

"Sorin H"

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message >
> Use DROP DATABASE ....

I did but when I recreate it all the tables appears on it
Sorin



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4462 (20090927) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



Mon, Sep 28 2009 7:25 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Sorin


If you're using the menus in EDBManager then when you click drop database you get first a confirmation prompt (answer is Yes) then a question asking if you want to keep the data (answer is No). If the data is still around there's a bug.

If you use the command "DROP DATABASE" then you have to specifically tell it to keep the data by adding KEEP CONTENTS otherwise it will all go. Again if it doesn't its a bug and should be reported along with the version of ElevateDB.

Roy Lambert [Team Elevate]
Mon, Sep 28 2009 11:20 AMPermanent Link

"Sorin H"

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news>
If you're using the menus in EDBManager then when you click drop database
you get first a confirmation prompt (answer is Yes) then a question asking
if you want to keep the data (answer is No). If the data is still around
there's a bug.

Yes it's still around with the ver 2.03
Sorin



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4464 (20090928) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



Mon, Sep 28 2009 12:25 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Sorin,

<< Yes it's still around with the ver 2.03 >>

This is absolutely not correct, so you should check what you're doing and
make sure that you've got it right.  Perhaps you're mistaking the .old
versions of the table files for the table files themselves ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Sep 29 2009 3:38 AMPermanent Link

"Sorin H"
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message >
> This is absolutely not correct, so you should check what you're doing and
> make sure that you've got it right.  Perhaps you're mistaking the .old
> versions of the table files for the table files themselves ?
>
As always you're correct.

Still the option to drop all the tables without droping the database can
help on some cases.
Thanks Sorin



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4465 (20090928) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



Tue, Sep 29 2009 4:18 AMPermanent Link

Uli Becker
Sorin,

> Still the option to drop all the tables without droping the database can
> help on some cases.

There are lots of useful things on Tim's list - so it doesn't make sense
to ask for a one-click-solution that can already  be done by writing 2
lines of code.

Regards Uli
Tue, Sep 29 2009 9:27 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Uli

>There are lots of useful things on Tim's list - so it doesn't make sense
>to ask for a one-click-solution that can already be done by writing 2
>lines of code.

Firstly I'd always leave that decision to Tim, whilst vigorously arguing for what I want naturally, but I'd also like to see two lines of code to drop all the tables but keep the database.

Roy Lambert
Page 1 of 2Next Page
Jump to Page:  1 2
Image