InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

"Peter Hearty" <peter.hearty@lutris.com> on 26/09/2000 03:17:35

Please respond to instantDB@enhydra.org

To:   instantDB@enhydra.org
cc:
Subject:  Re: InstantDB: Strange error when adding a column to a table

Peter,

It happens on both NT (dev) and Linux (prod) - haven't tried on Solaris.
SURVEYS.tbl exists in both environments.
The database and application work fine (selecting, inserting and updating),
that is, until I try to alter the table def, and chaos ensues.
Seems to render entire database unusable (not just that table).
I will try to abstract a small servlet which shows the problem and send it
to you.
I appreciate the advice on export - I need to do that for backup in any
case.

thanks
David

______________________________________________________________________________________________

"The surest sign that intelligent life exists elsewhere in the universe is
that it has never tried to contact us."
______________________________________________________________________________________________


David

I don't know for certain why you're being prevented from deleting the
surveys.tbl file. Are you on a Unix or Windows system? Maybe InstantDB is
having a filename case problem. could you check to see whether SURVEYS.tbl
actually exists? (As opposed to, say, "surveys.tbl").

Another possibility is that another JVM has the file open. Do you run any
database exploration tools that could have he database open at the same
time?

As a work around, to save you loosing data on the ALTER TABLE, you could
export, do a drop/create and then re-import. Something like this:

drop table tmp;
create table tmp (id int, data1 char(10));
insert into tmp values (1, "111");
insert into tmp values (2, "222");

set export "tmp.cvs" csvdelimited;
select tmp.*,"333" from tmp;
set export "null";

drop table tmp;
create table tmp (id int, data1 char(10), data2 char(10));
import "tmp" from "tmp.cvs";

Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com



-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.