General information
Title:
Assembling Data From Numerous 'Large' Server Tables
I'm creating a VFP application that reports on data from an Oracle Database at a remote location. The required information comes from several relational tables. My initial select results in a cursor of about 1500 rows. By creating paramatarized views - scanning the cursor and issuing requery(), I can assemble the information I need. What I really want to do is 'leave' the initial cursor on the server and perform subsequent queries using that cursor - only fetching the final result set. In most instances I need to perform outer joins because data may or not be present in the supporting tables. My initial select already requires an outer join - my understanding is that only one outer join is allowed per select under Oracle.
This seems like a routine requirement and should be obvious - but I haven't had any luck finding out how to do it.
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only