Invoke a trigger by SQL Insert ?

davachi

New Member
Hi All,
We need to invoke a progress trigger when ever a new record is added to a Progress 91B database table via ODBC SQL. The trigger for create works fine in 4GL, but does not work when a new record is created via SQL connection.

Any suggestion appreciated.

Thanks
:)
 

tamhas

ProgressTalk.com Sponsor
ABL triggers are not fired by SQL and SQL triggers are not triggered by ABL. Sorry. You have to create an equivalent trigger in Java.
 

TomBascom

Curmudgeon
Keeping 4GL and Java triggers synchronized is a real challenge.

Also, in general, the use of triggers is architecturally frowned upon.

Lastly... 9.1 is bad enough but 9.1 B??? :eek: Are you sure about that? You really, really ought to upgrade. If you're going to insist on staying with v9 you should at least get to 9.1E service pack 4. It's the very last service pack for v9 and it is several years old now but it is much, much better than 9.1B. (9.1B is older than some Progress developers...)
 

davachi

New Member
Thanks for the Reply and good advise. Unfortunately though we can't upgrade that easy. We need to find out how we can update an MSSQL table from HP-UX environment. If you have an idea in this would appreciate letting us know.
 

TomBascom

Curmudgeon
Why can't you upgrade? Do you enjoy using obsolete tools?

The "right" way to do it would be to separate the UI, BL and DB layers and to use an SOA approach to your application. Then your MS whatever stuff and your Progress stuff would both use a common routine to update the db perhaps using web services and/or an ESB to communicate.

That's a lot easier to implement if you are using an up to date release of progress.
 
Top