Hello, I am working on a business object layer routine that I need to combine the results of several tables into one cursor. All the tables have the same layout.
I am creating the cursor for the first table like: Select * from table1 where conditions into cursor1 Then I loop thru the tables and create additional cursors for the other tables like: Select * from table2 where conditions into cursor2 At the end, I want to combine the cursors together. I tried to use append from but it wants the cursors to be physical tables. I want to keep them cursors in memory. There must be an easy way to combine 2 or more cursors with the same structure ? Thanks, Kent _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/B8E920B138E048CCB490CE4290DB5D4C@LaptopW7 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
