Forum: Datenbanken
Delphi
by Hansa,
2. Dez 2003
Habe jetzt folgenden BI-Trigger:
AS
DECLARE VARIABLE ARTNR INTEGER;
begin
SELECT ANR FROM TEST_PROCEDURE INTO :ARTNR;
post_event ('ÖÄÖÄÖÄ'); /* INTO :ARTNR; */
INSERT INTO LAGER (ID_ART,BESTAND) VALUES (:ARTNR,NEW.BESTAND);
end
Forum: Datenbanken
Delphi
by Hansa,
2. Dez 2003
Habe mich kurzerhand entschlossen, doch eine SP zu verwenden 8)
ALTER PROCEDURE TEST_PROCEDURE
RETURNS (
ANR INTEGER)
AS
BEGIN
SELECT ID FROM ART INTO :ANR;
SUSPEND;
Forum: Datenbanken
Delphi
by Hansa,
2. Dez 2003
Habe das ganze etwas einfacher gemacht:
CREATE TRIGGER ART_BU0 FOR ART
ACTIVE BEFORE UPDATE POSITION 0
AS
DECLARE VARIABLE ANR INTEGER;
BEGIN
SELECT ID FROM ART INTO :ANR; /* Trigger text */
end