Graphics

 View Only
  • 1.  Excelrange vs DatalinqRange

    Posted 07-07-2019 14:06

    I hope you can help me with the following odd thing I have with DataLinq.

    I've got an Excelsheet with 243 rows, but DataLinq is only showing 200 of them. Now I think that round figure of 200 is a maximum within DataLinq but where can I change it? Is it something I can change?

    The very strange thing is, sometimes when I'm working in the sequencer, I can't see the rows above the 200 and sometimes I can????

    This happens as well in version XPression-Studio-6.5_3574 as in XPression-Studio-7.1_3949



  • 2.  RE: Excelrange vs DatalinqRange

    Posted 07-07-2019 18:08

    Hi Rob,

     

    There should be a config option in the ADODB datalinq configuration to adjust this.  It was added in version 6.5 as shown below.  I believe the setting is on the "advanced" tab in the ADODB config.

     

    version 6.5 build 3553 (January 12th 2016)

    1. [improved] the ADODB datalinq browser can now be customized to show more than 200 records (max 2000)


    #XPression


  • 3.  RE: Excelrange vs DatalinqRange

    Posted 07-07-2019 22:17

    Thanks Brian! That was something I could (should?) have found out myself. But I was put on the wrong foot because I can't remember I had this issue last year when I did the same show with the same DataLinq connection (different content). But that was probably because we than used the 6.5_3550 version.


    #XPression