PowerBuilder - ASE trigger causing resultset

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

ASE trigger causing resultset

Rene Hoeijenbos

2004-05-04, 3:17 pm

An insert into a sybase ASE database table, fires an insert trigger on
this table which(the trigger) returns a result set. The insert is
coded in embedded sql in powerscript in a event or window function.

The result is that I can't commit my transaction because "results are
pending". Powerbuilder doesn't know what to do with the value comming
from the inserttrigger.

In this case I insert a record into a inventorytransaction table. The
trigger gives me the generated transactionnumber. Is there a way that
Powerbuilder ignores this kind of resultsets. At the moment we are
using PB6.5.1.

Sponsored Links