We have a huge table (>100.000 records). We want implement an "incremental fetching" with TADClientdataset: that means we want to load gradually the demanded part of the table.
For example: first load only the records beginning with records where PK like "B" and so on, next with records where PK like "X" enlarge the TADClientdataset etc
Wenn I try to rewrite the select statement in 2. fetch (instead of parameter), then at append a message comes: "402 - Operation cannot be performed without assigned Selectcommand"
Your example: ADCommand1.Close; ADCommand1.Params[0].AsInteger := 2; ADCommand1.Open;
My example: ADCommand1.Close; ADCommand1.Commadtext[0] := ''select * from Orders where EmployeeID = 2'
