EDBManager v1.08 build 1 Unicode

1. Opened EDBManager.

2. Opened the session called Migration, which contains
all the tables migrated from DBISAM, using Administrator
and password=EDBDefault.

3. Then I tried this SQL statement on an existing table:
     ALTER TABLE LexTrans
     ADD COLUMN Russian VARCHAR(100)

4. SQL statement failed with this error:
"ElevateDB Error #403 The database Configuration is read-only
and this operation cannot be performed (ALTER TABLE LexTrans)"


What steps must I take to allow use of an ALTER statement?

Thanks,
Dan

Dan,

<< 3. Then I tried this SQL statement on an existing table:
     ALTER TABLE LexTrans
     ADD COLUMN Russian VARCHAR(100)

4. SQL statement failed with this error:
"ElevateDB Error #403 The database Configuration is read-only
and this operation cannot be performed (ALTER TABLE LexTrans)" >>

In the bottom-right-hand corner of the EDB Manager you'll see the current
session and database.  Make sure that you're accessing the proper database
by clicking on it in the left-hand treeview.  If you try to run the above
statement when the database is the Configuration database, you'll get that
error.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<< Make sure that you're accessing the proper database >>

Yep. It was so obvious once you pointed out my mistake. <blush>
I hope that other EDB newbies can learn from this...

Thanks for the rapid response!
Dan

Dan,

<< Yep. It was so obvious once you pointed out my mistake. <blush> I hope
that other EDB newbies can learn from this...  >>

It's not particularly obvious right away, but once you know, it's easy to
remember.

--
Tim Young
Elevate Software
www.elevatesoft.com