Procedure with pagination

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
vicens
Posts: 2
Joined: Sun 17 Jan 2016 11:37

Procedure with pagination

Post by vicens » Mon 02 May 2016 18:14

Hi,

I am using Unidac components for connect to a MSSQL Database.
Using a TUniquery component I connect with a stored procedure and usually that returns the rows succesfully.
When I try to connect with a stored procedure that use pagination I get the next message error:

"SQL statement doesn't return rows"

Anybody can tell me how I must configure the connection in this case ??

Thanks

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Procedure with pagination

Post by AlexP » Wed 04 May 2016 11:12

Hello,

Please send the scripts for creating the stored procedure. In addition, specify the versions of UniDAC and IDE.

Post Reply