I have a local view. This local view uses fields from a remote view. My remote view is parameterised to retrieve lines for a specified order. This works fine in isolation. I open the remote view using the NODATA clause in the DataEnv, then in the Init() of the form I retrieve the order id, then requery the view.
The problem is, that even when I open my local view with the NODATA clause, Fox still prompts me for the value of nOrder_id (which is required by the remote view). Even when I do the following from the command line I get the problem:
USE DBname!RemoteViewName NODATA &&-Parameterised
USE DBname!LocalViewName NODATA &&-Not parameterised
As soon as the second line is run it asks me for the order_id that the remote view needs to retieve order lines! Am I doing something wrong? Is this a bug? Is there a workaround?