Jump to content
Sign in to follow this  
fabriceN

SQL recursion

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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:

Share this post


Link to post
Share on other sites

Got a demo or example?

Share this post


Link to post
Share on other sites

ExecuteSQL() inside a Custom Function?

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.