>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?
Make nOrder_id as PUBLIC variable and initialize it to 0.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."