Problem with insert trigger

[datenis]

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?

 

[mirtheil]

If the accounting application is Btrieve based, it won't fire triggers.
Btrieve can't fire triggers, only ODBC.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[datenis]

Is there a way to get around this?

 

[mirtheil]

Get around what? Making Btrieve fire a trigger? No.
What are you trying to accomplish with the trigger?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[datenis]

We're doing ETL between to databases (A and B) and want to poll database A for changes and send them to database B.

Now knowing that triggers won't work the worst I can do is to replicate table A on a temp table and run queries on a join of the two for changes on the columns that I want.

But I want to know if there is a workaround before doing this.

 

[mirtheil]

If you're trying to keep the two databases synchronized, you might look at the Pervasive DataExchange product (

http://www.pervasive.com/dataexchange/index.asp).

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com