pRecordSet->PutMaxRecords(10); Doesnot work ?
-
I am Using ADO(Visual C++) and Access 2000 database. Trying to limit the number of records returned by the recordset with PutMaxRecords(x), and the recordset returns all records. Thanks for your help in advance.
This will not work on an Access database, see here [^]. If you are still want to do something like that you could change your
SELECTstatement to look something like this:"SELECT TOP 10 * FROM [myTable] WHERE user_id = 1"Hope This Helps :) Nick Parker
**The goal of Computer Science is to build something that will last at least until we've finished building it. - Unknown
**
-
This will not work on an Access database, see here [^]. If you are still want to do something like that you could change your
SELECTstatement to look something like this:"SELECT TOP 10 * FROM [myTable] WHERE user_id = 1"Hope This Helps :) Nick Parker
**The goal of Computer Science is to build something that will last at least until we've finished building it. - Unknown
**