SQL server retrival on demand
-
Ok, I have an assignment in front of my that demands that I build a sql statement on the fly and then populate a listbox. No problem , except only retrieve say first 100 rows. Then as the user hits the right scroll retrieve 100 more at a time till such time no more rows are left. Any examples out there or suggestions. Thanks:^)
-
Ok, I have an assignment in front of my that demands that I build a sql statement on the fly and then populate a listbox. No problem , except only retrieve say first 100 rows. Then as the user hits the right scroll retrieve 100 more at a time till such time no more rows are left. Any examples out there or suggestions. Thanks:^)
SELECT TOP 100 FROM tbl WHERE sortfield > lastid ORDER BY sortfield ---------- There go my people. I must find out where they are going so I can lead them. - Alexander Ledru-Rollin