Data Transformation from 4GL to SQL92

[lchlee]

Hi fellows!

I made SQL92 trigger. There's no problem with SQL92 trigger
It works very well.
However, there is just one problem.
We have application using 4GL. This application is connected
with another application using SQL92.
Actually, the former insert one row into table. Spontaneously,
the latter should be upgraded by trigger.

There's no response in the latter when some action such as
insert happen in the former.

Do 4GL go well with SQL92?
I think that whether some action on table happens by 4GL or
not, trigger which is made by SQL92 has to work.

Am I wrong?

I look forward to receiving any buddy's great response and
comment.

 

[mra]

Hi!

You're out of luck here, because sql92 triggers do NOT fire if you update the database from 4GL, and vice versa. You have to comminucate in some other way (sockets).



Kind regards
Mike