With the following code I was used to remove some records that should not be there (due to an issue somewhere in the software):
SELECT t.*, t.ROWID
FROM ifsapp.mpccom_accounting_tab t, ifsapp.purchase_transaction_hist_tab x
WHERE t.accounting_id = x.accounting_id
AND x.transaction_id = :enter_transaction_id;
In the button bar for the data grid there is then a + and a - button that should be enabled. But those are not enabled in this version. In 12.8 PA it works correctly.
Thread created by w.delange
With the following code I was used to remove some records that should not be there (due to an issue somewhere in the software):
SELECT t.*, t.ROWID
FROM ifsapp.mpccom_accounting_tab t, ifsapp.purchase_transaction_hist_tab x
WHERE t.accounting_id = x.accounting_id
AND x.transaction_id = :enter_transaction_id;
In the button bar for the data grid there is then a + and a - button that should be enabled. But those are not enabled in this version. In 12.8 PA it works correctly.