Filtering Rows to Warehouse (OpenInsight 32-Bit) [Revelation On-Line Wiki]

OpenInsight 32-Bit, Alexander Holliday

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 20 APR 2011 11:33:59AM Alexander Holliday wrote:

I am looking for a hook in the Warehouse Manager.

When running a Warehouse Procedure in the Warehouse Manager, is there any way to filter the rows which are being warehoused? I have inserted a line in the WP_ program :

Ret=SQLExp_Select(Table, Info)

*ret=1

call activate_save_select('KEYSIG_LT_D')

which does this. The value of Ret can either be set to 1 or left to the original line.

Is there a more elegant way to do this? I could not find any place to intervene and insert a select list in the Warehouse Manager.

I also was unable to locate any documentation for SQLExp_Select.

View this thread on the Works forum...