TSQLQuery.SavetoStream and PacketRecords

[taqtaq]

How does TSQLQuery.savetostream?

I try to save into a file a dataset with 10 records but when I use SaveToStream, it saves the entire contents of the table.

For example, with a TSQLQuery.packetrecord := 10 and a Table with 10,000 records, savetostream saves into the file 10000 records.

I just want to save the 10 records that are loaded in the TSQLQuery

Thanks

[goodname]

The TSQLQuery.packetrecord := 10 means that ten records are loaded at a time. More are loaded as required. If you only want 10 then modify the query to return 10 records at a time. This gets database specific but common SQL key words are TOP and LIMIT.

[taqtaq]

Thanks for your quickly answer.
I see you're right
But maybe I have to create a routine to save only what is in memory
Thank again