Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: TClientDataSet PacketRecords error


This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Jan 3, 2018 11:41 AM Last Post By: Jeff Overcash (... Threads: [ Previous | Next ]
Carlos Matos

Posts: 114
Registered: 6/25/01
TClientDataSet PacketRecords error  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 3, 2018 9:22 AM
This was intrioduced earlier on Delphi Berlin and a fix was lunched later and that was fixed.
After installing Delphi Tokyo update 2, I get the following error when scrolling on a grid that has a datasource linked to a TClientDataSet with PacketRecords <> -1.
This ClientDataSet is connect to a datasnap server.

The error is:
Remote error: XSQLDA index out of range.

and this happens on line 5220 of Datasnap.DBClient.pas.

Some debug code:
(0055D4B1){Pos2011_CLiente2686.exe} [0095E4B1] Datasnap.DBClient.TCustomClientDataSet.DoGetRecords (Line 5220, "Datasnap.DBClient.pas" + 4) + $49
(00011698){Pos2011_CLiente2686.exe} [00412698] System.@CheckAutoResult (Line 38448, "System.pas" + 4) + $6
(0055D4B1){Pos2011_CLiente2686.exe} [0095E4B1] Datasnap.DBClient.TCustomClientDataSet.DoGetRecords (Line 5220, "Datasnap.DBClient.pas" + 4) + $49
(00554DFF){Pos2011_CLiente2686.exe} [00955DFF] Datasnap.DBClient.TCustomClientDataSet.FetchMoreData (Line 1709, "Datasnap.DBClient.pas" + 6) + $38
(00557557){Pos2011_CLiente2686.exe} [00958557] Datasnap.DBClient.TCustomClientDataSet.GetRecord (Line 2672, "Datasnap.DBClient.pas" + 8) + $6
(002AAEA5){Pos2011_CLiente2686.exe} [006ABEA5] Data.DB.TDataSet.GetNextRecord (Line 13993, "Data.DB.pas" + 9) + $17
(002AB6D7){Pos2011_CLiente2686.exe} [006AC6D7] Data.DB.TDataSet.MoveBy (Line 14364, "Data.DB.pas" + 16) + $5
(002A2A61){Pos2011_CLiente2686.exe} [006A3A61] Data.DB.TDataLink.MoveBy (Line 10596, "Data.DB.pas" + 1) + $B

This was running ok with Delphi Tokyo update 1. What was changed? You guys from Embarcadero should awake, please, do not kill what was running ok.
Any ideas?
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: TClientDataSet PacketRecords error  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 3, 2018 11:41 AM   in response to: Carlos Matos in response to: Carlos Matos
On 1/3/2018 12:22 PM, Carlos Matos wrote:
This was intrioduced earlier on Delphi Berlin and a fix was lunched later and that was fixed.
After installing Delphi Tokyo update 2, I get the following error when scrolling on a grid that has a datasource linked to a TClientDataSet with PacketRecords <> -1.
This ClientDataSet is connect to a datasnap server.

The error is:
Remote error: XSQLDA index out of range.

and this happens on line 5220 of Datasnap.DBClient.pas.

Some debug code:
(0055D4B1){Pos2011_CLiente2686.exe} [0095E4B1] Datasnap.DBClient.TCustomClientDataSet.DoGetRecords (Line 5220, "Datasnap.DBClient.pas" + 4) + $49
(00011698){Pos2011_CLiente2686.exe} [00412698] System.@CheckAutoResult (Line 38448, "System.pas" + 4) + $6
(0055D4B1){Pos2011_CLiente2686.exe} [0095E4B1] Datasnap.DBClient.TCustomClientDataSet.DoGetRecords (Line 5220, "Datasnap.DBClient.pas" + 4) + $49
(00554DFF){Pos2011_CLiente2686.exe} [00955DFF] Datasnap.DBClient.TCustomClientDataSet.FetchMoreData (Line 1709, "Datasnap.DBClient.pas" + 6) + $38
(00557557){Pos2011_CLiente2686.exe} [00958557] Datasnap.DBClient.TCustomClientDataSet.GetRecord (Line 2672, "Datasnap.DBClient.pas" + 8) + $6
(002AAEA5){Pos2011_CLiente2686.exe} [006ABEA5] Data.DB.TDataSet.GetNextRecord (Line 13993, "Data.DB.pas" + 9) + $17
(002AB6D7){Pos2011_CLiente2686.exe} [006AC6D7] Data.DB.TDataSet.MoveBy (Line 14364, "Data.DB.pas" + 16) + $5
(002A2A61){Pos2011_CLiente2686.exe} [006A3A61] Data.DB.TDataLink.MoveBy (Line 10596, "Data.DB.pas" + 1) + $B

This was running ok with Delphi Tokyo update 1. What was changed? You guys from Embarcadero should awake, please, do not kill what was running ok.
Any ideas?

Actually XSQLDA range errors will be coming from InterBase. You probably should
be looking at the server side for why this is happening (and the client you are
using to access InterBase).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02