Re: Creating a trigger in Pervasive SQL 2000i

You can test a triger two ways -- issue the command that fires the
trigger, or use the core code to build a stored procedure (i.e. the
CREATE PROCEDURE command) and CALL that procedure from either your
application, the PCC, or another procedure.

As for seeing the trigger, you'll have to query the X$Trigger table
directly -- there is no way to see the trigger from the PCC (at least
that I am aware of). To modify the trigger, issue a DROP TRIGGER and a
subsequent CREATE TRIGGER statement.

I believe that PSQLv9 has improved the handling of triggers
dramatically, and would recommend that you upgrade to that version, if
you need this functionality.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/27/06 ***

portCo wrote:

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

  • Re: Autoincremental field in VFP7
    ... I made a gross mistake and pointed you to CREATE TRIGGER ON INSERT .command. ... ALTER TABLE x ALTER COLUMN keyfield Int AUTOINC [NEXTVALUE NextValue[STEP ... You triugger would not fail if you used this command ...
    (microsoft.public.fox.helpwanted)
  • Re: troubleshooting tools - IIS Crash/Hang agent
    ... Will is leave IIS running in the case of a hang situation? ... It doesn't> include any built-in functionality such as: sending email to> administrator when the server crashes. ... it supports a command> line trigger to run any commands when the server is crashed. ...
    (microsoft.public.inetserver.iis)
  • Re: newsyslog command in an script
    ... > feedback from the newsyslog command in the form of an script ... exposition of csh programming is considered harmful, ... If so what would the csh script command look like to perform ... enough to trigger newsyslog. ...
    (freebsd-questions)
  • Re: Update Style to Match Selection
    ... command to trigger the particular box Greg asked about. ... in which case the Modify Style dialog refuses to appear). ... Herb Tyson MS MVP ...
    (microsoft.public.word.newusers)
  • Re: view
    ... the SELECT command inside the view and the SELECT (or other ... the underlying tables are read. ... Roy Harvey ... if i want "updating" then i should create a trigger or stored ...
    (comp.databases.ms-sqlserver)