KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

OFFSET Error with SQL Server 2008 #2734

Open jram opened this topic on on Jun 20 - 1 comments

jram commented on Jun 20

Hi,

i'm having problems with Tables and SqlSrv connection:

This is my function

 protected function onCreated()
    {
        $this->manageTable("Custtable")->inSource(Axapta::class);
    }

Axapta is a SQLServer connection:

use \koolreport\dashboard\sources\SQLServer;

class Axapta extends SQLServer
{
    protected function connection()
    {
        return [
            "connectionString"=>"sqlsrv:server=****;Database=****",
            "username"=>"alex",
            "password"=>"******",
            "charset"=>"utf8"
        ];
    }
}

And when I try to access this page, it throws this error:

Message: Query Error >> ["42000",102,"[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '0'."] >> SELECT Custtable.ACCOUNTNUM, Custtable.NAMECOMER, Custtable.NAME, Custtable.weblogin, Custtable.PHONE, Custtable.zipcode FROM Custtable OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY || Sql params = [] || Search params = []

It seems that OFFSET command not works with this version of SQL Server but i don't know how can i fix it...

Sebastian Morales commented on Jun 21

Unfortunately, current Dashboard's query builder only targets SQL Server 2012 and later versions. We will pass this to the dev team to see if they can support SQL Server 2008 sql syntax.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None