Hi, I need some help getting data back from a remote server hosting mySQL,
I have a database on the server that has a table called members which has 10,000 records, Ive designed a little program with an ADODC object and a few textboxes which I have bound to this control & fields in the table. The ADODC object calls a DSN connection called HOME which points to the I.P of the remote server. When I start the application with "SELECT * FROM members" it takes forever to open up.
I have limited the number of records that my ADODC object returns by using "SELECT * FROM members LIMIT 0, 10" this is much faster
I have placed this code in the ADODC object's recordset Command Text Box.
What I now want to do is if the User scrolls through the records and gets to record number 10, I want to get the next 10 records from the members table.
I believe you can do this by using this select statement :-
"SELECT * FROM members LIMIT 10, 10"
Now this is all well and good but where do I put this code? Do I need to open a new recordset for these records or can I replace the previous records in the recordset?
I have got First/Prev/Next/Last buttons on the screen do these need to have code behind them keeping track of what record the User is on?
Anyhelp would be very much appreciated, or if you could point me in the direction of a help file or website that would be great!
Many Thanks
Martin
I have a database on the server that has a table called members which has 10,000 records, Ive designed a little program with an ADODC object and a few textboxes which I have bound to this control & fields in the table. The ADODC object calls a DSN connection called HOME which points to the I.P of the remote server. When I start the application with "SELECT * FROM members" it takes forever to open up.
I have limited the number of records that my ADODC object returns by using "SELECT * FROM members LIMIT 0, 10" this is much faster
I have placed this code in the ADODC object's recordset Command Text Box.
What I now want to do is if the User scrolls through the records and gets to record number 10, I want to get the next 10 records from the members table.
I believe you can do this by using this select statement :-
"SELECT * FROM members LIMIT 10, 10"
Now this is all well and good but where do I put this code? Do I need to open a new recordset for these records or can I replace the previous records in the recordset?
I have got First/Prev/Next/Last buttons on the screen do these need to have code behind them keeping track of what record the User is on?
Anyhelp would be very much appreciated, or if you could point me in the direction of a help file or website that would be great!
Many Thanks
Martin
