I have had to resort to this more than once and it has helped me. Usually it is a private DS environment setting. What I do is DISPLAY/LIST STATUS under the conditions where it works and again under the conditions where it fails. I then compare all the settings.

A better way would probably be to create a 2-D array in the form and populate with the environment variable and current setting [get all the variables from the SET DATASESSION list in the VFP Help]. Create another array with the settings in your default data session [DS #1]. Then compare the 2 arrays in the debugger.

>Hi everyone,
>I have a strange situation with a cursor formed from 2 remote views. Data from the second view doesn't show up when I run the code in a method, but does when I run the same code in a PRG.

>
>USE rv1 in 0  && Data shows correctly if I Browse it
>
>USE rv2 in 0  && Data shows correctly if I Browse it
>
>SELECT rv1.*, rv2.* from rv1 ;
>   left outer join rv2 on rv1.IDField = rv2.IDField ;
>   into cursor curTemp

>curTemp shows NULL values for all the rv2 fields in my form method, but shows the correct data when the exact same code is run from a PRG. I know the LOJ is running correctly, because one of the 4 result records doesn't have a link to rv2.
>
>I tried the same code using a WHERE clause linking the two tables. Three records showed the correct rv1 data, but again nulls for the rv2 data in the form method. The record without a link to rv2 was missing as expected in this version.
>
>Anybody see what I'm missing? Or what the difference could be between PRG and form method?
>
>TIA,
>Barbara
>TIA,
>Barbara