SELECT * FROM cursor1 ; UNION ALL SELECT * FROM cursor2; etc INTO CURSOR curall READWRITE
Fred On Wed, Sep 7, 2011 at 3:27 PM, Kent Belan <kbe...@mchsi.com> wrote: > 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 > > [excessive quoting removed by server] _______________________________________________ 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/CAJCBksq7rZNNweghbL6nCwGpp=o=ydqhnjucoqbekwdpoou...@mail.gmail.com ** 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.
