Subject | Re: [firebird-support] error firebird v2.5.4 using trigger and hash function and update or delete record same content |
---|---|
Author | Mark Rotteveel |
Post date | 2015-08-11T10:53:49Z |
On 10 Aug 2015 14:23:44 -0700, "emailx45@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
application? If so, show exactly what you're doing.
This indicates you have a syntax error somewhere
context of this question.
Mark
<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