SQL recursion

[fabriceN]

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!

[David Wikström]

RTFM

I can't find any functionality listed that would allow for recursion.

[fabriceN]

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:

[bruceR]

Got a demo or example?

[beverly]

ExecuteSQL() inside a Custom Function?

[fabriceN]

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)