On 10 Aug 2015 14:23:44 -0700, "[email protected] [firebird-support]" <[email protected]> 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
