Hello I have a following question:
I have a table with thousands of rows which i need to show in a String Grid ( I use Borland Delphi with MyDac component which implements MySQL interface). If i make a query SELECT * FROM tbl WHERE col1="something", it can cause retreival of 10,000 records and my program will just eat all the Windows resources and die :) So i need to retreive first 1000 of rows, then on user's request, next 1000, etc. If i use SELECT ... LIMIT 1000, it just retreives first 1000 of records, which doesn't resolve my problem. Any ideas would be highly appreciated! Thank you, Andrey PS. Please respond to my email address directly, as i am not able to subscribe to the mailing list. --------------------------------- Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!