Have you ever wanted data to be returned a page at a time? For example the data you requested returns 200 rows and you want to return them to the user 1 page at a time? Well now you can!
PS!! Do not forget to rate this software. This results in more code!! Thanks.
Original Author: Barry Pranklin
Inputs
ConnectString As String
Sql As String
ShowPage As Long
PageSize As Long
Assumptions
You will need these objects. They come with VB6
Microsoft ActiveX data objects 2.1 Library
Microsofr Remote Data services server 2.1 Library
Returns
Rs As ADODB.Recordset
ErrorC As String
PageCount As Long
Side Effects
None that I know of.
Attachments
| File | Uploaded | Size |
|---|---|---|
| CODE_UPLOAD30601252000.zip | 9/3/2020 3:45:00 PM | 4114 |