On 06/07/2017 08:08, Ashif Ahamed wrote:
When there is some data bringing looping scenario : *INSERT INTO FOLDER VALUES(2, 'Loop Data', 5);* After inserting this loop data , when i trigger the above recursive query in SQLite it keeps on running without bringing any results. Note: In oracle database , this kind of scenario is handled by connect by nocycle prior or cycle column set is_cycle to '1' default '0' How to handle this scenario in SQLite? Can anyone look on into this..
You could use one of the three techniques suggested in this document. https://www.dropbox.com/s/5tsh7lod3oqv3h5/Tuto19-Recursive-programming.pdf?dl=0 J-L Hainaut _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
