Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Disappearing Data
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Disappearing Data
Miscellaneous
Thread ID:
00458703
Message ID:
00458703
Views:
52
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
Barbara Paltiel, Paltiel Inc.
Next
Reply
Map
View

Click here to load this message in the networking platform