ClientDataSet 'Insufficient memory for this operation'

Usually this happens when you have a lot of data to return. Since you are not explicit about what you intend to do, I suggest trying to use FetchAll .

SQLConnection1.Params.Values['FetchAll'] := 'False';

Remembering that if the problem really is the number of records returned from the bank, it might be a re-examination of the business rule.

The problem is related to the BDE and how it uses memory to perform its operations. Every Delphi programmer has gone through this and usually cursed the BDE for this behavior. I strongly recommend that you reconsider using BDE and start using newer technology such as FireDAC or UniDAC.

To resolve, open BDE Admin , click the Configurations tab. Click the + sign next to System , and then click INIT . On the right side of the screen there will appear a series of settings, one of them is SHAREDMEMSIZE that should have a value of 2048 . Change this value to 4096 , give an ENTER and apply the change by pressing CTRL + A . Restart the application that is using BDE and verify that the error persists.

References to other errors and their solutions can be found at the following link

link