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.

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

Tim,

what address should I use? When I try to send it to support@elevatesoft.com I get
"Transaction failed - unsolicited attachments" error.


Marcin

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

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 It is no problem to upload
this file
to group.

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 It is
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

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

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

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.

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.