Fetching data for a Business Entity with a recursive relation Cancel

1. Gerry Holderbeke

   

   4 posts
   Registered:
   08 Nov 2018
   11 Jan 2021

   Link to this post

   Hi,
   Is it possible to do a fetchdata on a Business Entity with a recursive relation?
   If I try that I get errors from the fetchdatainternal method, saying:
   FILL of buffer eTABLE with user-supplied query requires that the query be QUERY-PREPARED. (11876)
   Regards,
   Gerry H.
   
2. Mike Fechner

   

   319 posts
   Registered:
   14 Sep 2016
   11 Jan 2021 in reply to Gerry Holderbeke

   Link to this post

   It is certainly possible.
   
   What's your Data-Source style? 
3. Gerry Holderbeke

   

   4 posts
   Registered:
   08 Nov 2018
   11 Jan 2021 in reply to Mike Fechner

   Link to this post

   Progress-Consultingwerk-CCE style :-s ?
   
   No kidding, what do you mean with style?
   

   Last modified on 11 Jan 2021 08:01 by Gerry Holderbeke
4. Mike Fechner

   

   319 posts
   Registered:
   14 Sep 2016
   11 Jan 2021 in reply to Gerry Holderbeke

   Link to this post

   it's a setting in the Business Entity Designer. It controls is DATA-SOURCE object's are generated of BufferDataSource's via a factory.
5. Gerry Holderbeke

   

   4 posts
   Registered:
   08 Nov 2018
   11 Jan 2021 in reply to Mike Fechner

   Link to this post

   It is: DATA-SOURCE.
   
   I found out that with a simpler BE that the query passed correctly. It's probably due to our CCE add-ons. I'll try to avoid those.
   May the table with recursion have child tables during the query processing? Are there any known restrictions?
   
6. Mike Fechner

   

   319 posts
   Registered:
   14 Sep 2016
   11 Jan 2021 in reply to Gerry Holderbeke

   Link to this post

   Not caused by our Data Access class. Recursions are handled by the ProDataset itself.