INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Triggers - Available in P.SQL 2000i?

Triggers - Available in P.SQL 2000i?

(OP)
Does anyone know if Triggers were/are available in Pervasive SQL 2000i?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Triggers - Available in P.SQL 2000i?

Yes, there were available but have the same limitation as current versions.  That limitation being that once a trigger is created, the corresponding Btrieve operation is disabled.  For example, if you create an Insert Trigger, Btrieve Inserts will return a status 149.   

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Triggers - Available in P.SQL 2000i?

(OP)
That doesn't sound too promising to me.  What use is an insert trigger if the application cannot insert a new record without an error?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Triggers - Available in P.SQL 2000i?

It's not very useful unless the entire application is SQL based.   

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Triggers - Available in P.SQL 2000i?

(OP)
Pervasive SQL based?  Or SQL based?  Your answer confuses me even more.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Triggers - Available in P.SQL 2000i?

The SQL interfaces of PSQL.  They are ODBC, OLEDB (adCmdTable or adCmdText), ADO.NET, JDBC, and PvQuery (in PDAC).  If you use the Btrieve, ActiveX, JCL, OLEDB (adCmdTableDirect), or PvTable (PDAC) interface, adding a trigger will cause an error.  
A little closer to real life, Macola uses the Btrieve interface to access PSQL.  If you were to add an Insert trigger to one of the tables, Macola would return status 149 on each insert.  Inserts through SQL (like Pervasive Control Center, ODBC Test, etc) would work and would fire the trigger.   

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Triggers - Available in P.SQL 2000i?

(OP)
I am talking about PSQL not Macola.  So if I created an insert trigger - even though the insert was done with Macola - is this is possible with the Pervasive Control Center?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Triggers - Available in P.SQL 2000i?

If you create an Insert Trigger through the PCC, and issue an Insert statement through PCC, it will work.  If you try to insert to the same table using Macola (or any Btrieve application), a status 149 will be returned and no insert will occur.   

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Triggers - Available in P.SQL 2000i?

(OP)
Mirthiel,

To be clear, Macola - this older version at least - runs on Pervasive SQL, not btrieve.  Does this make a difference?  why are you calling Macola a btrieve application?

Macola USED TO run on btrieve 6.15 but that was 10 years ago.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Triggers - Available in P.SQL 2000i?

Btrieve was the product name for v6.15 but with the introduction of PSQL 7 (before PSQL 2000) Btrieve became an interface method to the engine.   An application uses the Btrieve interface to the engine whether it is 6.15 or 7 or 2000 or v8 or v9 of v10.  
Macola uses the Btrieve interface to the PSQL engine.  
There is a second interface method to the PSQL engine.  It is the SQL or SRDE interface like ODBC, OLEDB, etc.  
 

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close