Re: Creating a trigger in Pervasive SQL 2000i

I've looked at the manual and created a trigger. However, it is not
same as the MSSQL. In MSSQL, when I create a trigger I can see the file
I created and I can modify it as well. But in psql I can't find it. Is
there a way I can see and modify my trigger in PSQL? When I created the
trigger, the pop-up window said "Stored Procedure was succesfully
created.".

I want to make sure I am doing right.
- create a trigger in "Stored Procedure" (right click + new stored
procedure) using Pervasive SQL Control Center
- Where Can I test it? I don't know where I can test that trigger. (I
tried to add a new row in database to fire the trigger; however, it
didn't work - "Insert Value does not match column list")

Any help would be appreciated =)

Thanks guys

.

Relevant Pages

  • Triggers, @@Identity and TADOQuery
    ... I am trying to set up simple auditing functionality for my users on ... MSSQL using the brute-force, trigger way. ... I create a trigger on MyTable which writes records into MyAuditTable. ...
    (borland.public.delphi.database.ado)
  • Re: Synchronisation MSSQL -> Postgres
    ... einbinden und direkt in einem Trigger oder einer stored procedure ... ODBC' klappt auch, ich habe mich beim Test an folgender Beschreibung ... kennt jemand eine gute Beschreibung für Trigger in MSSQL (für ...
    (de.comp.datenbanken.misc)
  • Re: trigger each row
    ... > into the trigger instead? ... It's a pitty that MSSQL doesn't support row-level triggers at all. ...
    (microsoft.public.sqlserver.programming)
  • Performance question on triggers
    ... MSSQL 2000 Given a table ... x,a,b,c float ... by using a trigger: ... set nocount off ...
    (microsoft.public.sqlserver.programming)
  • Re: chooses not to generate code at all
    ... >>>DBMS is so that the DBMS engine can execute it when triggered by some ... If there is no trigger, ... Stored procedure is one thing. ... > If the procedure execution is not triggered by DBMS ...
    (comp.object)