OK - so WH is not available in runtime. So how does it work? You need a development system attached to the database just for warehousing. That's understood (bit raw, but understood). Now we want WH on UPDATES ONLY. As far as I can see, when you place UPDATES ONLY on LH tables, it adds an MFS to the table. This causes a change to be written to SYSLISTS. Fine - excepting that SYSLISTS is now in the runtime system. So how does WH manager in the development system get to know about them? You cannot attach the SYSLISTS table in runtime to development system… WHAT DO WE DO???

Nick,

You cannot attach the SYSLISTS table in runtime to development system…

I'm not sure which bothers me more:

a) the problem you described exists and should be considered a bone-headed mistake

b) the possibility of such an obvious problem never occurred to me

Please accept my apologies and the following helpful program:

<code>
function XQSetTable(pTable)

*****************************************************************************
*
* Name       :  XQSetTable
* Description:  Specify the lists table to use for updates-only warehousing
* Parameters :  Table in - the name of the table to use instead of SYSLISTS
*                            (defaults to SYSLISTS)
* Returns    :  TRUE$ on success, FALSE$ on error
*
* History (Date, Initials, Notes)
*   08/12/98  cp   Original programmer.
*
*****************************************************************************

$insert Logical
common /XQ/ XQ_Initialized@, XQ_f_SysLists@

Table=SYSLISTS"
if assigned(pTable) then
  if len(pTable) then
    Table=pTable
  end
end

open Table to Handle then
  XQ_f_SysLists@ =Handle
  XQ_Initialized@=TRUE$
  Ret=TRUE$
end else
  Ret=FALSE$
end

return Ret

</code>

Just call this program with the name of the table to use instead of SYSLISTS.

Cameron Purdy

Revelation Software

Whoahhh!

Way to go Cam - talk about prompt responses….

May I echo Andrew's sentiments.

BTW - we did manage to attach the runtime SYSLISTS table to the development system, but not by using any method of which you would approve.

Thanks again for the help.

Nick

View this thread on the forum...