| 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-11T12:07:54Z |
On Tue, 11 Aug 2015 13:09:27 +0200, "'Bogdan' bogdan@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
exception is delete ... returning ... as it only returns a single row), a
delete statement will simply delete everything that matches the where
clause.
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.
Mark
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> I believe there is no PK in the table, so engine doesn't know whatrecord
> to deleteA 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
clause.
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.
Mark