I thought I'd test the delete speed on a table of mine (c130k rows with lots of indices including customised FTI)

Received an error 601 - cannot find index page during retrieval from cache
Repaired the table (wow processor intensive)
Tried deleting again (delete from mandn) and get same error message


Roy Lambert

Just tried repairing again and now I get error 700 table or view does not exist

Roy Lambert

Roy,

See here:

http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=19&msg=423&page=1

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< Just tried repairing again and now I get error 700 table or view does not
exist >>

Which table, the table that you are trying to repair ?

Please try to include the full error message.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< Just tried repairing again and now I get error 700 table or view does not
>exist >>
>
>Which table, the table that you are trying to repair ?

Yup, table I'm trying to repair

>Please try to include the full error message.

How's about you make them copyable - much easier than tabing between the two apps


Roy Lambert

Roy,

<< Yup, table I'm trying to repair >>

What happens when you try to repair the table after a shutdown and restart
of the EDB Manager ?  Same thing ?  Are you running this as straight SQL or
by selecting the Repair Table option on the selected table ?

<< How's about you make them copyable - much easier than tabing between the
two apps >>

Do you mean the standard Windows message dialog for exceptions ?  Or the
special SQL error message section in the SQL task pane ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


I was just thinking of yours but since you raise the issue it could well be a windows error. What about including MadExcept in EDBMan?

Roy Lambert

ps

Are you (at some point) going to make the other customised components available so we can alter and compile.

Roy,

<< I was just thinking of yours but since you raise the issue it could well
be a windows error. What about including MadExcept in EDBMan? >>

Source code issue.  EDB Manager comes with complete source code, just like
DBSYS.

<< Are you (at some point) going to make the other customised components
available so we can alter and compile. >>

They're already available in the \edbmgr\source subdirectory in the
edbutilcomps.pas unit.  You have to install them manually into the Borland
User Components package in the IDE if you want to use them, but that's it.
Their icons for the component palette could use some sprucing up also.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< I was just thinking of yours but since you raise the issue it could well
>be a windows error. What about including MadExcept in EDBMan? >>
>
>Source code issue. EDB Manager comes with complete source code, just like
>DBSYS.
>
><< Are you (at some point) going to make the other customised components
>available so we can alter and compile. >>
>
>They're already available in the \edbmgr\source subdirectory in the
>edbutilcomps.pas unit. You have to install them manually into the Borland
>User Components package in the IDE if you want to use them, but that's it.
>Their icons for the component palette could use some sprucing up also.


Never thought to go looking - I was spoilt by DBISAM where it installed them itself.

Roy Lambert

Roy,

<< Never thought to go looking - I was spoilt by DBISAM where it installed
them itself. >>

We don't install them automatically anymore because with DBISAM we kept
getting support questions about them due to customers thinking that they
were officially part of the DBISAM component set.

--
Tim Young
Elevate Software
www.elevatesoft.com