![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 10 of 14 total |
![]() |
Wed, Sep 3 2008 10:25 AM | Permanent Link |
Marcin | Hello,
I am trying to drop table constraint in script and server returns AV error. The script code: BEGIN EXECUTE IMMEDIATE 'ALTER TABLE "CodecFile" DROP CONSTRAINT "FK_CodecFile_Manufacturer"'; EXCEPTION IF ERRORCODE <> 401 THEN RAISE; END IF; END; Error: ElevateDB Error #900 An error occurred with the statement at line 64 and column 25 (Access violation at address 00532459 in module 'edbsrvr.exe'. Read of address 00000004) The code to create constraint: BEGIN EXECUTE IMMEDIATE 'ALTER TABLE "CodecFile" ADD CONSTRAINT "FK_CodecFile_Manufacturer" FOREIGN KEY(ID) REFERENCES Manufacturer(ID)'; EXCEPTION IF ERRORCODE <> 400 THEN RAISE; END IF; END; When I try to drop contraint in ElevateDB Manager I got the same error. Regards Marcin. |
Wed, Sep 3 2008 3:06 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Marcin,
<< I am trying to drop table constraint in script and server returns AV error. >> Please send me the database catalog (edbdatabase.edbcat in the database directory) that you're using via email. Thanks, -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Sep 4 2008 9:48 AM | Permanent Link |
Marcin | Tim,
what address should I use? When I try to send it to support@elevatesoft.com I get "Transaction failed - unsolicited attachments" error. Marcin |
Thu, Sep 4 2008 2:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Marcin,
<< what address should I use? When I try to send it to support@elevatesoft.com I get "Transaction failed - unsolicited attachments" error. >> Are you sending it from the email address that you're using here ? Because that email address is already on our white list, and should work fine for attachments. That email address that you're sending to is fine. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Sep 5 2008 11:32 AM | Permanent Link |
Marcin | Tim,
>> Are you sending it from the email address that you're using here ? Because >> that email address is already on our white list, and should work fine for >> attachments. That email address that you're sending to is fine. We have a person responsible for purchasing software. He is using its own address to comunicate therefore my address is not in your database ![]() this file to group. Attachments: EDBDatabase.EDBCat.zip |
Fri, Sep 5 2008 2:39 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Marcin,
<< We have a person responsible for purchasing software. He is using its own address to comunicate therefore my address is not in your database ![]() no problem to upload this file to group. >> In the future, please upload any attachments to the Binaries newsgroup. I'm not seeing any AV with the Build 5 candidate code and the constraint is dropped successfully, so it has either been fixed already or executing the script that you posted in the EDB Manager is not reproducing it. Can you reproduce this with a fresh load of the EDB Manager ? If so, then it is definitely already fixed, so I'll have to see if I can correlate this to an existing fix. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Sep 8 2008 3:33 AM | Permanent Link |
Marcin | Tim,
>> In the future, please upload any attachments to the Binaries newsgroup. Sorry for that will post to binaries next time. >> Can you reproduce this with a fresh load of the EDB Manager ? I am using build 2.01 4 so it is the latest at the moment. When build 5 will be available I will test it and post the answer. Thank you for help. Marcin |
Mon, Sep 8 2008 1:59 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Marcin,
<< I am using build 2.01 4 so it is the latest at the moment. When build 5 will be available I will test it and post the answer. >> It should be ready within the next two days. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Sep 15 2008 10:35 AM | Permanent Link |
Marcin | Hi,
I just tried build 5. The error is still there. Now I get "ElevateDB Error #900 An error occurred with the statement at line 240 and column 25 (Access violation at address 004CBC63 in module 'edbsrvr.exe'. Read of address 65727289)". Additionally ElevateDB Manager is useless right now. I have a script like this: BEGIN EXECUTE IMMEDIATE 'ALTER TABLE "CodecFile" DROP CONSTRAINT "FK_CodecFile_Manufacturer"'; EXCEPTION IF ERRORCODE <> 401 THEN RAISE; END IF; END; With code to delete about 50 tables 30 scripts and 10 triggers. While debugging, when only few tables or functions exists, I have to step on every exception although I wrote code to handle it. It is very annoying! I hardly can use ElevateDB Manager now. Marcin. |
Mon, Sep 15 2008 11:16 AM | Permanent Link |
Marcin | Hi Again,
I create may database using script. It is 3500 lines long. I create tables, functions procedures and triggers. When I run this script in version 5 not all procedures are created! It was all OK in build 4 so I will revert to that version. I have another simple script. It creates 20 tables and 4 stored procedures (tables do not have any constaints except primary) this scripts executes fine and everything is created. Hope build 6 will be better. Marcin. |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |