-
Mar 2nd, 2021, 04:13 AM
#1
Thread Starter
Junior Member
Too much records
Hello,
I am doing an program that read from a table in a database.
That table has 25 rows and when i execute the program prints to display thousands of rows.
Why i caught this error and how i solve it?
Here is the code :
rdoQry.SQL = "SELECT * FROM message"
rdoQry.RowsetSize = 1
Debug.Print rdoQry.SQL
Debug.Print "//////////////////////////////////"
Set rdoQry.ActiveConnection = cnMySql
Set rdoRS = rdoQry.OpenResultSet(rdOpenKeyset, rdConcurRowVer)
Do Until rdoRS.EOF
Debug.Print rdoRS!id
rdoRS.MoveNext
Loop
-
Mar 2nd, 2021, 04:30 AM
#2
Thread Starter
Junior Member
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|