>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
>
>USE rv2 in 0
>
>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?
IF your Method code is in a .VCX...
I've had a couple of instances where a .VCX has been subtly corrupted. Everything looked fine in the method editor, and even looking at the .VCT memo field directly, but *something* was wrong.
You could try deleting all the method code and re-typing it by hand (do NOT use cut-and-paste); if that doesn't work, delete the method, add it again, then re-type the code.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up