View Single Post
  #2 (permalink)  
Old 03-21-07, 07:19
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
First, 8.60 is PSQL V8 SP2. PSQL V8.7 is SP3.
Second, why are you needing to do a trigger? In PSQL, once a trigger is defined on a table, Btrieve access is disabled. For example, you list an "AFTER UPDATE" in the CREATE TRIGGER. Once this trigger is created, Btrieve applications will not be able to update that table. Only SQL based apps will be able to update the table.
Post your actual CREATE TRIGGER statement. Pseudocode won't help if there's a syntax error.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.