Forums / SmartComponent Library - Developer Forum / Fetching data for a Business Entity with a recursive relation

Fetching data for a Business Entity with a recursive relation

6 posts, 0 answered
  1. Gerry Holderbeke
    Gerry Holderbeke avatar
    4 posts
    Registered:
    08 Nov 2018
    11 Jan
    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
    Mike Fechner avatar
    216 posts
    Registered:
    14 Sep 2016
    11 Jan in reply to Gerry Holderbeke
    Link to this post
    It is certainly possible.

    What's your Data-Source style? 
  3. Gerry Holderbeke
    Gerry Holderbeke avatar
    4 posts
    Registered:
    08 Nov 2018
    11 Jan 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
    Mike Fechner avatar
    216 posts
    Registered:
    14 Sep 2016
    11 Jan 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
    Gerry Holderbeke avatar
    4 posts
    Registered:
    08 Nov 2018
    11 Jan 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
    Mike Fechner avatar
    216 posts
    Registered:
    14 Sep 2016
    11 Jan in reply to Gerry Holderbeke
    Link to this post
    Not caused by our Data Access class. Recursions are handled by the ProDataset itself.
6 posts, 0 answered