RE: INSERT .. UPDATE DUPLICATES - no trigger is fired

--- > From: Dusan Kolesar [mailto:[EMAIL PROTECTED] > Sent: Montag, 27. August 2007 10:36 > To: MaxDB mailing list > Subject: INSERT .. UPDATE DUPLICATES - no trigger is fired > > Hello, > I'm using MaxDb 7.6.00.37 on Linux OS (CentOS). > > when I do INSET stateme

INSERT .. UPDATE DUPLICATES - no trigger is fired

Hello, I'm using MaxDb 7.6.00.37 on Linux OS (CentOS). when I do INSET statement wiht UPDATE DUPLICATES database engine works incorrectly. Only when INSERT is performed trigger is fired. On UPDATE none triger is fired. Here is an example: CREATE TABLE "ADMIN"."TB" (

Re: Problem with trigger

I can not use foreign keys because i want to use this database in replication, thanks by the new idea for the trigger :). Zietlow, Elke escribió: > Hi, > > obviously you are not familiar with the feature of referential constraints, > which are very common and implemented in MaxDB,

RE: Problem with trigger

to be used in hotel's column zip. --> The error coming in your first try (invalid zip) is not the result of your trigger, but the result of this referential constraint. Now to your trigger: you are selecting ALL zips from city, but only fetching the first one and only checking this. -->

RE: Problem with trigger

Linos wrote : > -Original Message- > From: Linos [mailto:[EMAIL PROTECTED] > Sent: Montag, 6. August 2007 22:20 > To: maxdb@lists.mysql.com > Subject: Problem with trigger > > Hello all, > i am trying to do a trigger that permits me be sure > that whe

Problem with trigger

Hello all, i am trying to do a trigger that permits me be sure that when the users inserts a row use a list of possible good values to any of the columns from other table where i maintain this list, i would like to have this list dynamic instead of a constraint because i dont want to touch

RE:Invalid trigger after upgrade from 7.4 to 7.6 (AK Catalog information not found)

Kolja Kleist wrote : >Hello List, >After upgrading my database from sapdb 7.4.3.32 to maxdb 7.6.0.34 >I got an error when deleting a row from a specific table: >AK Catalog information not found >I found a posting from this list which says that the delete trigger may have >a p

RE: Dinamic statement in trigger

Dusan Kolesar wrote : > > > Dusan Kolesar wrote : > > > >> >> > >> >> Hello, > >> >> is it possible to access trigger variables in dinamic sql > >> statement: > >> >> > >> >> CREATE TRIGGER EMPLOYE

Re: Dinamic statement in trigger

On Mon, 15 Jan 2007 14:53:14 +0100, Anhaus, Thomas <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote : >> >> Hello, >> is it possible to access trigger variables in dinamic sql statement: >> >> CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE

RE: Dinamic statement in trigger

Dusan Kolesar wrote : > >> > >> Hello, > >> is it possible to access trigger variables in dinamic sql > statement: > >> > >> CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE > >> ( > >>VAR > >>

Re: Dinamic statement in trigger

On Mon, 15 Jan 2007 08:27:22 +0100, Anhaus, Thomas <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote : Hello, is it possible to access trigger variables in dinamic sql statement: CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE ( VAR EVENTTABLEID FI

RE: Dinamic statement in trigger

Dusan Kolesar wrote : > > Hello, > is it possible to access trigger variables in dinamic sql statement: > > CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE > ( >VAR > EVENTTABLEID FIXED(10); > COLNAME VARCHAR(30); > STMT VARCHAR

Dinamic statement in trigger

Hello, is it possible to access trigger variables in dinamic sql statement: CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE ( VAR EVENTTABLEID FIXED(10); COLNAME VARCHAR(30); STMT VARCHAR(100); COLCHNG FIXED(38); I FIXED (38); SET COLCHNG = 0; SET I

Invalid trigger after upgrade from 7.4 to 7.6 (AK Catalog information not found)

Hello List, After upgrading my database from sapdb 7.4.3.32 to maxdb 7.6.0.34 I got an error when deleting a row from a specific table: AK Catalog information not found I found a posting from this list which says that the delete trigger may have a problem. But when I try to select the triggers

RE: DELETE TRIGGER/DEFAULT SERIAL/DELETE KEY combination fails

James Prosser wrote: > Hi All, > > My first foray into DELETE TRIGGER has struck a problem > demonstrated by the > following SQL through websql into MaxDB >Kernel Kernel 7.6.00 Build 016-123-109-428 >Runtime EnvironmentW32/INTEL 7.6.00 Build 016-123-1

DELETE TRIGGER/DEFAULT SERIAL/DELETE KEY combination fails

Hi All, My first foray into DELETE TRIGGER has struck a problem demonstrated by the following SQL through websql into MaxDB Kernel Kernel 7.6.00 Build 016-123-109-428 Runtime Environment W32/INTEL 7.6.00 Build 016-123-109-428 CREATE TABLE "myTable" ("myTableID"

RE: IGNORE TRIGGER : Is it valid in a procedure?

H wrote: > > version:7.5.00.34 > platform: Windows 32 > > This is the same problem I am still working on. I found > that the 'IGNORE TRIGGER' compiles or works in a trigger statement. > > Question: Is the IGNORE TRIGGER syntax supposed to w

IGNORE TRIGGER : Is it valid in a procedure?

version:7.5.00.34 platform: Windows 32 This is the same problem I am still working on. I found that the 'IGNORE TRIGGER' compiles or works in a trigger statement. Question: Is the IGNORE TRIGGER syntax supposed to work in a procedure? Merely to be OO princi

RE: Simple Trigger code not working as expected? Sample code attached

H [mailto:[EMAIL PROTECTED] wrote: > > > I am having trouble writing a successful trigger according to > the sample code. > > (Gosh I am hoping the Forum isnt cross-posted to the list > because I put this in the forum as well). > > Below you will see: &g

(ver: 7.6) Simple Trigger code not working as expected?

Just realized I didnt post the version # it is 7.6 (sorry for the 2nd post). I am having trouble writing a successful trigger according to the sample code. (Gosh I am hoping the Forum isnt cross-posted to the list because I put this in the forum as well). Below you will see: a) A

Simple Trigger code not working as expected? Sample code attached

I am having trouble writing a successful trigger according to the sample code. (Gosh I am hoping the Forum isnt cross-posted to the list because I put this in the forum as well). Below you will see: a) A simple schema creation statement b) A simple insert statement for some sample data

Re: Problem creating Trigger

Hello Thomas, thanks for your help. I wasn't aware that a delete-statement which deletes no rows inside a trigger fires a catch. The SQL-Studio didn't even show a error. Is there a special return-code for "nothing deleted"? After executing the trigger with an empty cat

problem with trigger after update

Hello list, I'm trying to run a trigger on the following table T_PHARMACOECONOMICS id serial(10)... ... visit_date date oneyear_date date fiveyear_date date ... I need the values of oneyear_date and fiveyear_date be automatically generated from the visit_date column. I wrote a trigge

Trigger fireing

Hello list, I'm using MaxDb 7.6.00.16 on WinXP Home, SP2. I find that UPDATE trigger fires always when I call UPDATE, even though no value is changed. In version SapDb 7.4.3.32 (I heve used before) when UPDATE statement didn't change any value then no update trigger fired. Is it a n

Problem creating Trigger

Hello list, i'm quite amused by my own stupidity while trying to create the following trigger : CREATE TRIGGER ECOUPON_UPDATE FOR ECOUPON AFTER UPDATE EXECUTE ( TRY IF NEW.INVOICE_UUID IS NOT NULL AND NEW.CREDIT_UUID IS NOT NULL THEN BEGIN DELETE FROM SCHEMA1.AGG_INVOICE WHERE

RE: Any way to trigger a backup in conjunction with AutoLog?

Hi Fred, > Thanks for your reply. I'm currently using MaxDB 7.5.00.32, and the > dbmevtdisp program appears to work differently than what the online > documentation suggests. That documentation discusses the > commands add, > delete, list, start, state, stop, and version, but the syntax for th

RE: Any way to trigger a backup in conjunction with AutoLog?

log.048) as well as the reference to the pipe device that DP uses (such as /var/opt/omni/tmp/TST.BACKDP-Archive). -Original Message- From: Werner, Marc-Philip [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 20, 2005 5:48 AM To: maxdb@lists.mysql.com Cc: Claypool, Fred Subject: RE: Any w

FK preventing UPDATE Trigger from working

I have laid out the scenario below. Essentially my question is why does a FK delete restriction prevent my update trigger from working? ... I'm not deleting I am updating. * [Child table has foreign key defin

RE: Any way to trigger a backup in conjunction with AutoLog?

Hi Fred, > The only problem then is that those files sit there until our > regularly > scheduled external backup tool (HP's Data Protector) comes to > move them > onto tape. Is there any triggering or event mechanism built > in to MaxDB > that I could configure that would notify the backup tool

Any way to trigger a backup in conjunction with AutoLog?

(This was also posted to the MaxDB Forum on forums.mysql.com.) Hi there. Quick question for you. For over a year now, we've had Auto Logging enabled on all of our MaxDB databases. (We're currently running 7.5.00.31 on HP-UX & Linux.) This works great... when the log space fills up, MaxDB auto

AW: Antw: AW: temp table in trigger

Elke Schmidtke wrote : > >Hi Elke, > >I receive the message during creation of the trigger. >The table does not exist in the moment of creation. > >The original code I want to use in the trigger is >TRY > DELETE FROM TEMP.ATZ_VIEW; >CATCH >

Antw: AW: temp table in trigger

Hi Elke, I receive the message during creation of the trigger. The table does not exist in the moment of creation. The original code I want to use in the trigger is TRY DELETE FROM TEMP.ATZ_VIEW; CATCH CREATE TABLE TEMP.ATZ_VIEW (...); Procedures work perfect with code like this

AW: temp table in trigger

Elke Schmidtke wrote: > > Hi, > I try to create a temp table in a trigger: > CREATE TRIGGER TR_INSUPD_ATZ_WB FOR DBA.T_ATZ_WB > AFTER INSERT, UPDATE EXECUTE ( > CREATE TABLE TEMP.ATZ_VIEW ( > BEGINN DATE, > ENDE DATE, > BESETZTE_STD FIXED(5,2),

temp table in trigger

Hi, I try to create a temp table in a trigger: CREATE TRIGGER TR_INSUPD_ATZ_WB FOR DBA.T_ATZ_WB AFTER INSERT, UPDATE EXECUTE ( CREATE TABLE TEMP.ATZ_VIEW ( BEGINN DATE, ENDE DATE, BESETZTE_STD FIXED(5,2), FREIE_STD FIXED(5,2), MODELL CHAR(2)); ) But get the

AW: [FSID] MaxDB and the mystery trigger

Andreas Goldstein wrote : > >Hi Listmembers, > >I played with the trigger of a basetable ssturm.ARTIKEL, but now I >run into trouble as shown below: > ><-- BEGIN --> > >DROP TRI

Re: [FSID] MaxDB and the mystery trigger

bonjour, Le dimanche 02 octobre 2005, Andreas Goldstein a écrit... Oups ! > DROP TRIGGER UT_ARTIKEL OF ssturm.ARTIKEL > // > /***/ > /* Error --- */ > /*

Re: [FSID] MaxDB and the mystery trigger

bonjour, Le dimanche 02 octobre 2005, Andreas Goldstein a écrit... > DROP TRIGGER UT_ARTIKEL OF ssturm.ARTIKEL > // > /***/ > /* Error --- */ > /* Auto

[FSID] MaxDB and the mystery trigger

Hi Listmembers, I played with the trigger of a basetable ssturm.ARTIKEL, but now I run into trouble as shown below: <-- BEGIN --> DROP TRIGGER UT_ARTIKEL OF ssturm.ARTIKEL // /***/ /*

AW: [FSID] Strange trigger

Andreas Goldstein wrote : > >Hi Listmembers, > >I created the following table and used it without problems. >Later I add the >two trigger shown below. Since I added the trigger I have to enter all >Insert- and Update-statements two times before they take >effect? This c

[FSID] Strange trigger

Hi Listmembers, I created the following table and used it without problems. Later I add the two trigger shown below. Since I added the trigger I have to enter all Insert- and Update-statements two times before they take effect? This can be noticed inside my VB-DB-Application as well as by using

Problem with calling dbproc in the trigger

Hello, I'm using SapDb 7.4.3.31 under Win2000(SP4). I have a table and on insert trigger for it. Trigger only call some DbProcedure: CREATE TABLE A ("TXT" Varchar (100) ASCII) // CREATE DBPROC TEST AS VAR x Integer; SET x=0; // CREATE TRIGGER A_INSERT FOR A AFTER INSERT EX

AW: [FSID] Inside a Trigger - is it possible to identify the event that fires the trigger?

Andreas Goldstein wrote : > > >Hi Listmembers, > >what I would like to know is the following: >Is it possible to get information about the event that activates the >trigger? What I mean is, if there is a way to get the information the >trigger has been fired because of an

RE: [FSID] Bug in CREATE TRIGGER with Schema ?

I wrote: > ... > > I tried to define a trigger using this code-snippet: > CREATE VIEW OR REPLACE sstorm.VTB_sellings AS SELECT ... > > After that I tried to use this view by an ODBC-connected program, > but it fails, so I checked it in SQL Studio again. In the left >

[FSID] Bug in CREATE TRIGGER with Schema ?

Hi Listmembers, today I tried the follwing: I have DB-Instance with 8 tables in it. These are all in a SCHEMA called 'sstorm' ;) Now I logged into that instance with the SQL Studio using my new girlfriend MONA with her top secret password RED :) There I tried to define a trigger using

[FSID] Inside a Trigger - is it possible to identify the e vent that fires the trigger?

Hi Listmembers, what I would like to know is the following: Is it possible to get information about the event that activates the trigger? What I mean is, if there is a way to get the information the trigger has been fired because of an UPDATE-Statement und use this information inside the triggers

RE: [FSID] Delete-Trigger problem

OK, I got it! ;) As I searched in the deep of this mailinglist I found the solution to this issue: http://lists.mysql.com/maxdb/5178 (February 20 2002 12:54pm) What is stated there is, that only UPDATE-TRIGGER will have NEW and OLD, so for my purposes I have to modify my trigger as follows

[FSID] Delete-Trigger problem

Hi Listmembers! I am having problems to create a delete-trigger. Here is the example: CREATE TABLE address ( address_ID FIXED(10) DEFAULT SERIAL PRIMARY KEY, street VARCHAR(20), city VARCHAR(20), zipVARCHAR(5), region VARCHAR(2)) // CREATE TABLE customer ( customer_id FIXED(10

[FSID] Insert-Trigger and commit

Hi Listmembers, today I have the following question: I tried to develope an INSERT-Trigger that checks the value of one column in a new inserted row. The following example shows my idea: CREATE TABLE test2 ( id DEFAULT SERIAL PRIMARY KEY, telefon CHAR(20)) // CREAT TRIGGER telefontest FOR test2

AW: Problem creating trigger

Edson Carlos Ericksson Richter wrote : > >I've found an old mail saying that OLD and NEW works only in UPDTE >triggers. So, should I not use OLD in DELETE trigger too? > >Thanks, > >Richter > > >Edson Carlos Ericksson Richter escreveu: > >> Th

Re: Problem creating trigger

I've found an old mail saying that OLD and NEW works only in UPDTE triggers. So, should I not use OLD in DELETE trigger too? Thanks, Richter Edson Carlos Ericksson Richter escreveu: Thank you, you is right. I forgot the brackets... But now, if I stay with "if old.CO_SITUACAO &l

Re: Problem creating trigger

ists.mysql.com Objet : Problem creating trigger I'm creating a very simple trigger: create trigger TRG_PARCELA_DEL for TB_PARCELA after delete execute if old.CO_SITUACAO <> 2 then UPDATE MGR.TB_CC_ORCAMENTO SET VL_PROVISIONADO = VL_PROVISIONADO - :old.VL_NOMINAL_REAIS, VL_PAGO

Re: Problem creating trigger

Thank you, you is right. I forgot the brackets... But now, if I stay with "if old.CO_SITUACAO <> 2", I get "Table name must be in from list". If I remove the IF line, compiles ok. Any hints? Richter Frank Schimmelpfennig escreveu: Hi, perhaps it helps to put

Re: Problem creating trigger

Hi, perhaps it helps to put the trigger logic between brackets... Pls. see the code modifications below: create trigger TRG_PARCELA_DEL for TB_PARCELA after delete execute ( if old.CO_SITUACAO <> 2 then UPDATE MGR.TB_CC_ORCAMENTO SET VL_PROVIS

RE: Problem creating trigger

e : Edson Carlos Ericksson Richter > [mailto:[EMAIL PROTECTED] > Envoyé : jeudi 9 juin 2005 14:31 > À : maxdb@lists.mysql.com > Objet : Problem creating trigger > > > I'm creating a very simple trigger: > > create trigger TRG_PARCELA_DEL for TB_PARCELA after de

Problem creating trigger

I'm creating a very simple trigger: create trigger TRG_PARCELA_DEL for TB_PARCELA after delete execute if old.CO_SITUACAO <> 2 then UPDATE MGR.TB_CC_ORCAMENTO SET VL_PROVISIONADO = VL_PROVISIONADO - :old.VL_NOMINAL_REAIS, VL_PAGO = VL_PAGO - :old.VL_PAGO WHERE EXI

AW: AW: AW: A trigger stops my database

>>hints what's going wrong. >> >>Best Regards and thanks in advance >>Thomas >> >> >> >> >>>-Ursprüngliche Nachricht- >>>Von: Xavier CAMIER [mailto:[EMAIL PROTECTED] >>>Gesendet: Montag, 18. Oktober 2004 09:11 >>

Re: AW: A trigger stops my database

- Von: Xavier CAMIER [mailto:[EMAIL PROTECTED] Gesendet: Montag, 11. Oktober 2004 13:20 An: [EMAIL PROTECTED] Betreff: A trigger stops my database Good afternoon A trigger executed twice makes my database crashing. When the result is updated and NEWVARIABLE<>'' the t

A trigger stops my database

Good afternoon A trigger executed twice makes my database crashing. When the result is updated and NEWVARIABLE<>'' the trigger calls the TLIGNEMETRERESULTMAJ DBProc. The first time it is called everything happen as exepected. The 2nd time the trigger is started (with the same &q

Re: AW: General error;-6013 POS(1) Duplicate trigger definition

Anhaus, Thomas a écrit : Xavier Camier wrote Linux MaxDB 7.5.0.12 Good afternoon, I use triggers to automate some datas processes and everything worked fine... until today. The following trigger seems alright (it has been accepted by SQL Studio) but when I try to browse it from sql studio it

Re: AW: General error;-6013 POS(1) Duplicate trigger definition

Jean-Michel OLTRA a écrit : bonjour, Le jeudi 26 août 2004, Xavier CAMIER a écrit... Thank you for replying but as explained in the mail the trigger I created appears nowhere and that's my problem. Yes I did it and I'm wondering how it can be refused as it appears

Re: AW: General error;-6013 POS(1) Duplicate trigger definition

bonjour, Le jeudi 26 août 2004, Xavier CAMIER a écrit... > >>Thank you for replying but as explained in the mail the trigger I > >>created appears nowhere and that's my problem. > Yes I did it and I'm wondering how it can be refused as it appears &

Re: AW: General error;-6013 POS(1) Duplicate trigger definition

Sven Köhler a écrit : Thank you for replying but as explained in the mail the trigger I created appears nowhere and that's my problem. Have you upgraded the system-tables yet? Perhaps it helps. Just a guess. Here is something I just found. When I drop the table and then recreate it

Re: AW: General error;-6013 POS(1) Duplicate trigger definition

Sven Köhler a écrit : Thank you for replying but as explained in the mail the trigger I created appears nowhere and that's my problem. Have you upgraded the system-tables yet? Perhaps it helps. Just a guess. Yes I did it and I'm wondering how it can be refused as it appears nowh

Re: AW: General error;-6013 POS(1) Duplicate trigger definition

Thank you for replying but as explained in the mail the trigger I created appears nowhere and that's my problem. Have you upgraded the system-tables yet? Perhaps it helps. Just a guess. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:

Re: AW: General error;-6013 POS(1) Duplicate trigger definition

Anhaus, Thomas a écrit : Xavier Camier wrote Linux MaxDB 7.5.0.12 Good afternoon, I use triggers to automate some datas processes and everything worked fine... until today. The following trigger seems alright (it has been accepted by SQL Studio) but when I try to browse it from sql studio it

AW: General error;-6013 POS(1) Duplicate trigger definition

Xavier Camier wrote > >Linux >MaxDB 7.5.0.12 > >Good afternoon, > >I use triggers to automate some datas processes and everything worked >fine... until today. The following trigger seems alright (it has been >accepted by SQL Studio) but when I try to browse it fr

General error;-6013 POS(1) Duplicate trigger definition

Linux MaxDB 7.5.0.12 Good afternoon, I use triggers to automate some datas processes and everything worked fine... until today. The following trigger seems alright (it has been accepted by SQL Studio) but when I try to browse it from sql studio it does not appear in the trigger list. I'm

AW: Trigger question

Mathias Stroedler wrote : > >Hello, > >The statement gives an error? Why? What to do? Which from list? > >create trigger testtrigger for t2 after insert, update execute ( >if(New.t1_id =null) then >stop(37892493,'a message'); >) > >

RE: Trigger question

What I recognized right now is that the statement only fails for insert trigger. Update trigger seem to work. What's the reason? Hope, somebody can reduce my confusion! -Original Message- From: Stoedtler, Mathias [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 9:20

Trigger question

Hello, The statement gives an error? Why? What to do? Which from list? create trigger testtrigger for t2 after insert, update execute ( if(New.t1_id =null) then stop(37892493,'a message'); ) Error --- Auto Commit: On, SQL Mode: Oracle,

Re: AW: Timestamp Trigger

g the default column value to > > TIMESTAMP. > > > >For UPDATE the simple aproach: > >CREATE TRIGGER TEST_TIMESTAMP FOR TEST AFTER UPDATE > > EXECUTE ( > >UPDATE USER.TEST SET DATUM=TIMESTAMP WHERE > > TEST.ID=:NEW.ID; ) > >does not work. This caus

Re: AW: Timestamp Trigger

Hello Tobias, Try this: CREATE TRIGGER TEST_TIMESTAMP FOR TEST AFTER UPDATE EXECUTE ( IF (OLD.DATUM <> NEW.DATUM) THEN RETURN; UPDATE USER.TEST SET DATUM=TIMESTAMP WHERE TEST.ID=:NEW.ID; ) and when you make UPDATE don't update tstamp coluumn. Regards, Dusan. On Tue, 13 Jul 20

Re: AW: Timestamp Trigger

e > > corresponding data row. As I understand for INSERT this > > can be achieved by setting the default column value to > > TIMESTAMP. > > > > For UPDATE the simple aproach: > > CREATE TRIGGER TEST_TIMESTAMP FOR TEST AFTER UPDATE > > EXECUTE ( > > UP

AW: Timestamp Trigger

ue to TIMESTAMP. > >For UPDATE the simple aproach: >CREATE TRIGGER TEST_TIMESTAMP FOR TEST AFTER UPDATE EXECUTE >( >UPDATE USER.TEST SET DATUM=TIMESTAMP WHERE TEST.ID=:NEW.ID; >) >does not work. This causes the db kernel to crash every time >I execute an update on the t

AW: Timestamp Trigger

value to TIMESTAMP. > > For UPDATE the simple aproach: > CREATE TRIGGER TEST_TIMESTAMP FOR TEST AFTER UPDATE EXECUTE > ( > UPDATE USER.TEST SET DATUM=TIMESTAMP WHERE TEST.ID=:NEW.ID; > ) > does not work. This causes the db kernel to crash every time > I execute an update on

Timestamp Trigger

the mysql TIMESTAMP. That is: the timestamp column holds the date (and time) of the last modification of the corresponding data row. As I understand for INSERT this can be achieved by setting the default column value to TIMESTAMP. For UPDATE the simple aproach: CREATE TRIGGER TEST_TIMESTAMP

Re: Long data type and trigger OLD value

Vitaly Veksler wrote: I have created a trigger to do something with the previous value of a particular record. My trigger def looks like this: CREATE TRIGGER ANNOUNCEMENT_UPDATE FOR ANNOUNCEMENT AFTER UPDATE EXECUTE ( TRY INSERT INTO ANNOUNCEMENT_HISTORY VALUES

Long data type and trigger OLD value

I have created a trigger to do something with the previous value of a particular record. My trigger def looks like this: CREATE TRIGGER ANNOUNCEMENT_UPDATE FOR ANNOUNCEMENT AFTER UPDATE EXECUTE ( TRY INSERT INTO ANNOUNCEMENT_HISTORY VALUES ( :OLD.ANNOUNCEMENT_GID

Trouble with calling dbproc in the trigger

Hello, I'm using SapDb 7.4.3.32 under WinXp(SP1). I have a table and on insert trigger for it. Trigger only call some DbProcedure: CREATE TABLE A ("TXT" Varchar (100) ASCII) // CREATE DBPROC TEST AS VAR x Integer; SET x=0; // CREATE TRIGGER A_INSERT FOR A AFTER INSERT EXECUTE (

...problem with trigger and variable

Hi @all, i need some advice with an trigger statement. When i execute this statement in the SQL Studio, i became this error. Error --- Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed Syntax error or access violation;-3005 POS(1) Invalid SQL

Trigger crash database in 7.5.00.14

I've a database into which I use triggers to compute some fields values when inserting or updating a record. Until version 7.5.00.11, everything works fine. But in 7.5.00.14, the trigger crashes the database instance. It crashes when executing the update statement. CREATE TRIGGER TABLE1_U

Re: Trigger Translation from Oracle and PostgrSQL

Simple trigger calling a store procedure to do the work This two scripts new obviously two tables named "companias" and other named "periodos_contables" create trigger companias_trigger for companias after insert execute ( Call dba.sp_conta_addPeriodoContable(:NEW.ID_

Trigger Translation from Oracle and PostgrSQL

Hello everybody, I desperately need documentation on MaxDB Triggers. I have the reference manual, I need something more basic with examples. I have to translate Oracle PL/SQL and PostgreSQL PL/PGSQL Triggers to MaxDB. Here is a PL/PGSQL Trigger, if anyone has the skill and time to translate

Re: Trigger to update last date & time changed...

bonjour, Le lundi 17 mai 2004, Zabach, Elke a écrit... > INSERT INTO JM.HISTORIQUEGARANTIEINTRANT VALUES > ( > :OLD.IDGARANTIE, > :OLD.IDINTRANT, > :OLD.IDETABLISSEMENT, > DATE,< >

RE: Trigger to update last date & time changed...

in its been written 100 times > before - if someone would be so kind as to cut and paste it for me .. > > psuedo code > > Trigger on Table Customer > Before Insert or Update > Set DateField = Today() > Set TimeField = Now() > > Kind Regards, &g

Re: Trigger to update last date & time changed...

bonjour, Le dimanche 16 mai 2004, H a écrit... > I finally got something to compile and work as a trigger... I just need a couple of > missing pieces. What I want is a trigger that before an INSERT or UPDATE will set a > DATEfield to the current-date and a TIME field to th

Re: Trigger to update last date & time changed...

work as a trigger... I just need a couple of missing pieces. What I want is a trigger that before an INSERT or UPDATE will set a DATEfield to the current-date and a TIME field to the current time. What I have so far is below: CREATE TRIGGER UpdateDateTime for cm.todo after INSERT

Re: Trigger to update last date & time changed...

bonjour, Le jeudi 13 mai 2004, H a écrit... > Trigger on Table Customer > Before Insert or Update > Set DateField = Today() > Set TimeField = Now() SELECT DATE FROM SYSDBA.DUAL SELECT TIMESTAMP FROM SYSDBA.DUAL then have a glance to DATE functions,

Trigger to update last date & time changed...

t and paste it for me .. psuedo code Trigger on Table Customer Before Insert or Update Set DateField = Today() Set TimeField = Now() Kind Regards, - Post your free ad now! Yahoo! Canada Personals

Re: Again ignore trigger after update

1, "UPDATE"Integer NOT NULL DEFAULT 1, "DELETE"Integer NOT NULL DEFAULT 1, PRIMARY KEY ("ID") ) // INSERT TABLES SET NAME = 'Level' IGNORE DUPLICATES // ... other tables In the begining of every trigger is : CREATE TRIGGER LEVEL

RE: Again ignore trigger after update

Hi, I don't think you can conditionally by-pass firing trigger. But you should be able to achieve similar result by "conditionally" let the trigger does nothing. Here's an example. Let's say I have a CONTROL_TABLE with a single column FLAG If Flag = 0, fire trigger

Re: Again ignore trigger after update

Hello, I think that statement inside trigger tr_upd_atab_1 is incorrect: update dba.atab_2 set t2 = t2 + :val2, t3 = t3 + :val3 where t1 = 40 ignore trigger; I have searched for it in documentation but I didn't found "ignore trigger" statement. I think there is no way how to

Again ignore trigger after update

Hi all, we made an update for our database from SAPDB7.4 to MAXDB and have problems with triggers and procedures in which we use an update trigger with ignore trigger. Thomas Anhaus wrote 26.04.04 that it should still work, but our database crashes if we use the old triggers. I made a very little

RE: Ignore Trigger

Elke Schmidtke wrote : >We used ignore trigger for update triggers with SAPDB7.4. >Now we use MAXDB and are not sure if this still works. This should still work. >And another generell question: >does a trigger wait for the end of a procedure call before it continues >with the

Ignore Trigger

We used ignore trigger for update triggers with SAPDB7.4. Now we use MAXDB and are not sure if this still works. And another generell question: does a trigger wait for the end of a procedure call before it continues with the next statement ? Elke -- MaxDB Discussion Mailing List For list

Re: Trigger problem - database crash

Hello, I heve installed SapDB 7.4.03.31, but my problem is not solved. With the new version this trigger works like before. Regards, Dusan On Wed, 10 Mar 2004 15:38:14 +0100, Anhaus, Thomas <[EMAIL PROTECTED]> wrote: Hi Dusan, thanks for mailing the additional information. I noticed th

Re: Trigger problem - database crash

On Wed, 10 Mar 2004 11:17:11 +0100, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello, I have one problematic trigger. When I insert into LEVEL table, all database instance crash down. When there is the same trigger but without 2 lines: line 16 and 31 is EXECUTE inse

RE: Trigger problem - database crash

Dusan Kolesar wrote: > > > Hello, > > I have one problematic trigger. > When I insert into LEVEL table, all database instance crash down. > When there is the same trigger but without 2 lines: > line 16 and 31 is EXECUTE insertstmt; > everything is running and in the

RE: Trigger problem - database crash

Dusan Kolesar wrote : >Hello, >I have one problematic trigger. >When I insert into LEVEL table, all database instance crash down. >When there is the same trigger but without 2 lines: >line 16 and 31 is EXECUTE insertstmt; >everything is running and in the debug table TEST I c

Trigger problem - database crash

Hello, I have one problematic trigger. When I insert into LEVEL table, all database instance crash down. When there is the same trigger but without 2 lines: line 16 and 31 is EXECUTE insertstmt; everything is running and in the debug table TEST I can see all correct insert statemants. Trigger is

  1   2   >