Subject | RE: [firebird-support] error firebird v2.5.4 using trigger and hash function and update or delete record same content |
---|---|
Author | Bogdan |
Post date | 2015-08-11T11:09:27Z |
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 otherupdate
> 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
> any record with same values in your fields *-*-*-*-*-*-*-*-*-*-*These don't look like Firebird errors, is this coming from your
>
> .....Cannot delete record!
> .....There is at least one record with same fields value!
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 (orI am not sure what you mean with this, or how it would be relevant in the
> just DB_KEY) to control records (internal) in table when dont exist
> PrimaryKey or Index?
context of this question.
Mark
Ta e-pošta je bila pregledana z Avast protivirusnim programom.
|