Go to alter a table. Add a new column (integer if it matter).

Access violation at address 0045CB90 in module 'edbmgr.exe'. Read of address 00000024

The new column is actually added.

Roy Lambert

Roy,

<< Go to alter a table. Add a new column (integer if it matter).

Access violation at address 0045CB90 in module 'edbmgr.exe'. Read of
address 00000024

The new column is actually added. >>

It works fine here without any AV.  What if you restart the EDB Manager and
try it ?  Same result ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

Seems ok then - just tried it.


Roy Lambert

Tim

As part of the sorting the _ID field out, and after some other DDL activity I get it again so it looks like something being freed before its time


Roy Lambert

Roy,

<< As part of the sorting the _ID field out, and after some other DDL
activity I get it again so it looks like something being freed before its
time >>

Any ideas as to the steps leading up to it ?   While I appreciate the
reports, it doesn't really help me much if you don't provide any information
about the surrounding events.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


I shall spend time tomorrow seeing if I can replicate something for you. My brains given up today plus I've finally managed to create a database and tables in code - yippee - so I' leaving on a bit of a high.

Roy Lambert

Tim


>Any ideas as to the steps leading up to it ? While I appreciate the
>reports, it doesn't really help me much if you don't provide any information
>about the surrounding events.

Just tried again -

1. opened EDBMan
ALL THE BELOW IN THE Properties Pane
2. Double clicked the default session
3. double clicked the test database
4. doublr clicked tables
5. SIngle click table tester
6. Single click Alter Table
IN THE ALTER TABLE DIALOGUE
7. Typed xyz into Columns:Properties:Name
8. Single clicked Add Column
9. Single clicked OK

Result av

Interestingly after the above, and reverse engineering the database I tried to drop column qaz and also received an av, only this time the operation isn't successful and the column remains. I also tried to drop the column from the sql page for the database and still receive the same error.

Nothing else I can tell you unless you have a specific question.


/************************************************************
*
* ElevateDB Reverse-Engineered SQL for the Test database
*
* Generated on 28/01/2007 12:42:44
* By the user Administrator
*
************************************************************/


/************************************************************
* Tables
************************************************************/

CREATE TABLE "Tester"
(
"_ID" INTEGER GENERATED BY DEFAULT AS ,
"_Memo" CLOB COLLATE "ANSI",
"_Memo2" CLOB COLLATE "ANSI" COMPRESSION 6,
"xyz" CHAR(1) COLLATE "ANSI", <<<<<<<<<<<<<<<<<<<<<<< av when adding
"qaz" CHAR(1) COLLATE "ANSI"  <<<<<<<<<<<<<<<<<<<<<<< av when adding
)
VERSION 1
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
 
CREATE TEXT INDEX "Memo1" ON "Tester"
("_Memo" COLLATE "ANSI_CI")
INDEXED WORD LENGTH '30'
WORD GENERATOR "Default"
 

/************************************************************
* Views
************************************************************/


/************************************************************
* Functions
************************************************************/


/************************************************************
* Procedures
************************************************************/

/************************************************************
* End of generated SQL
************************************************************/

Roy,

<< Just tried again - >>

Alright, now we're cooking !

I've fixed the issue - it was just a selection display issue in the EDB
Manager.  I didn't catch it earlier because I tend to use the treeview for
navigation instead.

<< Interestingly after the above, and reverse engineering the database I
tried to drop column qaz and also received an av, only this time the
operation isn't successful and the column remains. I also tried to drop the
column from the sql page for the database and still receive the same error.
>>

So, an ALTER TABLE DROP COLUMN "xyz" doesn't work in the SQL window ?   It
should.

Also, this definition is wrong:

CREATE TABLE "Tester"
(
"_ID" INTEGER GENERATED BY DEFAULT AS ,  <<<<<<<<<<<<<  Incomplete

Did this come from the reverse-engineering ?  If so, can you send me the
edbdatabase.edbcat catalog for the database ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>Also, this definition is wrong:
>
> CREATE TABLE "Tester"
> (
> "_ID" INTEGER GENERATED BY DEFAULT AS , <<<<<<<<<<<<< Incomplete
>
>Did this come from the reverse-engineering ? If so, can you send me the
>edbdatabase.edbcat catalog for the database ?

Yes and yes. So even if I entered something wrongly, or didn't enter something its YOUR fault for not having sufficient error checking <vbcg>

Roy Lambert

ps Why when creating a database and tables for the first time do I still end up with the .edbcat.old?

Roy,

<< Yes and yes. So even if I entered something wrongly, or didn't enter
something its YOUR fault for not having sufficient error checking <vbcg> >>

Yep, the reverse-engineering wasn't generating IDENTITY columns properly.

<< ps Why when creating a database and tables for the first time do I still
end up with the .edbcat.old? >>

The database catalog file is backed up (copied) any time it is modified.
It's a fail-safe measure to ensure that there is always a last valid copy of
the catalog present in case of corruption.

--
Tim Young
Elevate Software
www.elevatesoft.com