Subject RE: [firebird-support] error firebird v2.5.4 using trigger and hash function and update or delete record same content
Author Bogdan

I believe there is no PK in the table, so engine doesn't know what record to delete

 

Regards,

 

Bogdan

 

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, August 11, 2015 12:54 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] error firebird v2.5.4 using trigger and hash function and update or delete record same content

 

 

On 10 Aug 2015 14:23:44 -0700, "emailx45@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:

> - I add new records mannually, add one new ID field value and the other
> fields have your values by TRIGGER BEFORE INSERT
> - Then, I try add 2 or more record with ID = 1
> - Later, I try delete any one record and I have this message:
>
> *-*-*-*-*-*-*-*-*-*-* Firebird error message when trying delete or
update
> any record with same values in your fields *-*-*-*-*-*-*-*-*-*-*
>
> .....Cannot delete record!
> .....There is at least one record with same fields value!

These don't look like Firebird errors, is this coming from your
application? If so, show exactly what you're doing.

> .....Error Message:
> .....----------------------------------------
> .....Invalid token.
> .....Dynamic SQL Error.
> .....SQL error code = -104.
> .....Unexpected end of command - line 2, column 66416683.
>
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

This indicates you have a syntax error somewhere

> Any idea for this error? The Firebird dont use Internal RDB$DB_KEY (or
> just DB_KEY) to control records (internal) in table when dont exist
> PrimaryKey or Index?

I am not sure what you mean with this, or how it would be relevant in the
context of this question.

Mark




Avast logo

Ta e-poŇ°ta je bila pregledana z Avast protivirusnim programom.
www.avast.com