Hi Bob,

no need to write complex queries in rev, create view and then write simple query for the view :-)

all the best
Viktoras

Bob Sneidar wrote:
The idea is to be able to page through large data sets by setting a limit on the number of records I return in the parent cursor, and then only return records in the "relational" cursors whose keys match the parent. I don't want to use the SQL relational system, because frankly writing rev code to build highly complex queries to return data from multiple tables into one cursor on the fly is more trouble than I want to deal with. I wish there was a way in SQL to set up linked cursors for relations, but alas it is what it is.


_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to