fabriceN Posted August 1, 2012 Share Posted August 1, 2012 Hi, did someone figure out if fql supports recursive queries? (not nested queries, really recursive)? I tried it using the Oracle syntax, but it doesn't seem to work. Thanks! Link to comment Share on other sites More sharing options...
David Wikström Posted August 2, 2012 Share Posted August 2, 2012 RTFM I can't find any functionality listed that would allow for recursion. Link to comment Share on other sites More sharing options...
fabriceN Posted August 7, 2012 Author Share Posted August 7, 2012 thanks David. I had rtfmed before posting Indeed, there is apparently no way. I finally combined a sql query and a FileMaker recursive function. Quite powerful ! :thumbup: Link to comment Share on other sites More sharing options...
bruceR Posted August 7, 2012 Share Posted August 7, 2012 Got a demo or example? Link to comment Share on other sites More sharing options...
beverly Posted October 27, 2012 Share Posted October 27, 2012 ExecuteSQL() inside a Custom Function? Link to comment Share on other sites More sharing options...
fabriceN Posted March 27, 2013 Author Share Posted March 27, 2013 Sorry, took a while, but here is an example file to manage hierarchal portals. (based on an example by Doug West, Excelisys) http://www.1-more-thing.com/Hierarchal-Portals-Using.html Actually, it's not the way I usually deal with hierarchies, I prefer a two-table model allowing many-to-many relationships, but this techniques allows it because you don't have to store the whole ascendence on each record. (which limits a record to 1 place only in the tree) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4040 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now