I've created an insert trigger that works if I add records manually
using PCC. But when I use our accounting app to insert a new record in
the same table the trigger doesn't fire. Thoughts?

Is your accounting application written in Btrieve or SQL/ODBC?

Currently, Pervasive triggers are NOT "universal", meaning that they
will NOT fire if INSERTS are done from the Btrieve layer. This is
documented in the manuals regarding the triggers. In fact, the inserts
may be failing (due to the trigger), and the accounting app may be
creating problems in its database in the process.

In short, if you have a Btrieve application, DO NOT use triggers. If
you have a SQL application (like the PCC, MSAccess, etc.), then
triggers are fully supported.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 07/2006 ***



datenisis wrote:

What good is a trigger if it cannot detect changes? Is there anyway to
get around this deficiency?

datenisis wrote:
It's an SQL trigger and it detects changes at the SQL level. An
unfortunate part of the Btrieve/PSQL legacy perhaps but that's the case.

If by that, you want SQL triggers to fire when a change is made via
the Btrieve interface then, no, there's no way round it that I know
of.

Guy
-- --------------------------------------------------------------------
Guy Dawson I.T. Manager Crossflight Ltd
gnues (AT) crossflight (DOT) co.uk

Guy Dawson wrote:
Let me rephrase this: Is there an effcient method for detecting
changes, perhaps using Btrieve, that works like a trigger?

If you are running on Windows or NetWare server (not Linux), then you
can take advanatge of Pervasive's AuditMaster product. This tool does
allow you to capture all database-level changes (and can even detect
READ operations if you want to).

It is an add-on product that requires a minimum version level, so an
upgrade may also be in the cards. (You never specified the DB version.)
Check our website at www.goldstarsoftware.com/am.asp for more
information.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 07/2006 ***

datenisis wrote: