Mark Rotteveel wrote Mon, 20 Jan 2020 09:57:34
+0300:
Both http://web.firebirdsql.org/download/snapshot_builds/win/4.0/ and
http://web.firebirdsql.org/download/snapshot_builds/linux/fbtrunk/
currently contain no snapshots.
Mark
Apparently the Linux snapshots were repaired, but there ar
On 03/02/2020 12:45, liviuslivius wrote:
> Hi
>
> It really should be rewritten/updated.
> 1. First select should use new type join kind not comma join kind.
> 2. Field po_number should be prefixed with alias of the table.
> 3. Order of exception and update should be reverted, sussped removed,
> al
On 03/02/2020 13:16, Leyne, Sean wrote:
>
>
>
> 3. Order of exception and update should be reverted, sussped removed,
> also maybe this update should be run in autonomous transaction but
> this is not nescessary as someone can commit after this error.
>
>
>
> AFAIK, an Exception “kills/termina
It really should be rewritten/updated.
1. First select should use new type join kind not comma join kind.
+1
2. Field po_number should be prefixed with alias of the table.
+1
3. Order of exception and update should be reverted, sussped removed, also
maybe this update should be run in autono
HiIt really should be rewritten/updated.1. First select should use new type
join kind not comma join kind.2. Field po_number should be prefixed with alias
of the table.3. Order of exception and update should be reverted, sussped
removed, also maybe this update should be run in autonomous transac
Hi!
In employee examples, there this kind of stored procedures:
---
CREATE PROCEDURE ship_order (po_num CHAR(8))
AS
DECLARE VARIABLE ord_stat CHAR(7);
DECLARE VARIABLE hold_stat CHAR(1);
DECLARE VARIABLE cust_no INTEGER;
DECLARE VARIABLE any_po CHAR(8);
BEGIN
SELECT s.orde
Firebird 4 Beta 1 rejects SQL 2003 compliant CREATE TRIGGER syntax
--
Key: CORE-6243
URL: http://tracker.firebirdsql.org/browse/CORE-6243
Project: Firebird Core
Issue Type: Bug
