TSQLquery and packetRecords

[Pabdym]

Hi,

My table contains up to 10000 rows. In my TSQLquery, PacketRecords := 1000. My request is asimple 'SELECT * FROM myTable;' It works fine...
But is there a variable in the TSQLquery which indicates that all the rows of the table were read?

Thanks.

[BigChimp]

Use the wiki, Luke
http://wiki.lazarus.freepascal.org/SqlDBHowto#Why_does_TSQLQuery.RecordCount_always_return_10.3F
So, either a .Last or change PacketRecords as mentioned there.

By the way, why would you want to load 10000 records at once? If you're going to show that to the user, he'll be flabbergasted
If you're going to want to modify it, why not run SQL commands against the server? (Ok, I understand that may not always be easiest/most convenient).

Edit: oh, welcome to the forum
Edit: also see:
http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F
... if you're going to ask questions next time, please mention OS, Lazarus+FPC version. Thanks.

[Pabdym]

Thank you for your welcome.
The problem is solved.
I take very good note of your remarks.
Goodbye.