Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 10 of 10 total |
Another buglet in b6 |
Fri, Jan 26 2007 10:12 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Jan 26 2007 1:59 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sat, Jan 27 2007 3:48 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Seems ok then - just tried it. Roy Lambert |
Sat, Jan 27 2007 8:51 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Sat, Jan 27 2007 10:51 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sat, Jan 27 2007 11:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Sun, Jan 28 2007 7:58 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 ************************************************************/ |
Sun, Jan 28 2007 10:45 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sun, Jan 28 2007 11:43 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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? Attachments: edbdatabase.edbcat.old edbdatabase.edbcat |
Mon, Jan 29 2007 6:34 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |