Subject RE: [firebird-support] error firebird v2.5.4 using trigger and hash function and update or delete record same content
Author Mark Rotteveel
On Tue, 11 Aug 2015 13:09:27 +0200, "'Bogdan' bogdan@...
[firebird-support]" <> wrote:
> I believe there is no PK in the table, so engine doesn't know what
> to delete

A delete statement doesn't need an unique identification of the row (the
exception is delete ... returning ... as it only returns a single row), a
delete statement will simply delete everything that matches the where

The error "Unexpected end of command" indicates that something goes wrong
before execution, during parsing the statement. That is why I asked you to
show exactly what you are doing: what statement you execute, or if you
don't execute a delete statement directly: how you are deleting the record.