Forums › Cached › Customization › Reporting › SuiteAnalytics Connect (ODBC)

This topic contains 1 reply, has 0 voices, and was last updated by Gear Source Dev 16 years, 3 months ago.

  • Author
    Posts
  • August 2, 2008 at 6:58 pm #8325

    Gear Source Dev

    Is there a limit to the number of records returned when using ODBC? I have to do (using CF to call .Net) a select top 100 to retrieve the first 100 records. If I do a select top 101 or greater than I receive no records back. Doing some searching on the forums I don’t find much but it wouldn’t appear to be capped at this tiny amount of records.
    This is a cached copy. Click here to see the original post.

  • August 3, 2008 at 9:25 am #8326

    Gear Source Dev

    RE: Record limit using ODBC

    Nevermind, found that the file openrda.ini has a FETCHBLOCK_SIZE property which controls the max amount of records returned.

  • Author
    Posts

You must be logged in to reply to this topic.