Hello William, Foxpro has all of the functions and constructs to do what you listed below, but I might suggest moving to a SQL SELECT command. Performance will be much better and I think in the long run the code will be more readable. In Foxpro, we can also sub-select. You will note that I am selecting into a CURSOR which is just an in-memory database/table.
SELECT Field1, Field2, Field3 FROM MyTable1 ; WHERE NOT Whatever ; ORDER BY Field1, Field2 ; INTO CURSOR CursorBasedOnTable1 && Comment - if we need to we can sub-select from the above cursor SELECT Field1, Field2, Field3 FROM CursorBasedOnTable1 ; WHERE Field2 = "Something" ; ORDER BY Field2, Field1 ; INTO CURSOR SubCursor2 && Comment - we could now report to printer or browse the data... BROWSE LAST NOWAIT I hope this helps, Kevin Tormey wrote: > BEGIN SEQUENCE - END SEQUENCE IN CLIPPER PROVIDES AN ABSOLUTE LOOP EXIT > AS IN > BEGSEQ > DO WHILE .T. > IF .NOT. WHATEVER > DO WHILE WHATEVER > IF .NOT. CALL FNC1() .OR. WHATEVER > EXIT > ENDIF > ENDDO > WHATEVER > MORE CONDITIONAL EXITS AND BREAKS > ENDDO > ENDSEQ > > FUNCTION FNC1() > CONDITIONAL > BREAK > END CONDITIONAL > RET .T. > ENDFNC > > A DO WHILE IN CLIP AND FOX GET YOU ONLY TO ITS OWN ENDDO, BUT THE BREAK > CARRIES YOU TO ITS END SEQ NO MATTER WHAT. SUPER FOR DEEPLY NESTED STUFF > WE USE FOR PROCESS CONTROL. > > PLEASE HOW DOES FOX DO THIS. MY SOLUTIONS ARE NOT ELEGANT AND THEREFORE > ERROR PRONE. > SEPAPHORES: - MESSY > LOOP AND SEMAPHORES:- NOT NICE EITHER > GOTO:- HEAVEN AND FOX FORBID > CALL TO C: WOULD BE NICE WE HAVE USED CLIPPER -C EXTENSIVELY, BUT THAT > ROUTE IS IN FOX EITHER. > > IF NOT FOX OR CLIPPER WHAT HOPE IT THERE ??? > WILLIAM TORMEY. > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
