So what this sub is supposed to do is read in the top 10 "runners" of a database and display their usernames and amount of runs through a String. The current sub only works for the first runner, the top 1. I'm not sure how to access the other "rows" of the database, the other 9. Any help with...
Once I know what each returns, I will be able to write code to do what I want, but for now: what do each of three give me? A table? An array? An int? Etc...I need to know what the postcondition is before I can proceed with the next step.
At least let me know what values they return, and how I can access them. I can most likely figure it out from there. For now, it would be stupid to do a String operator on an Integer, don't you think? (Just an analogy)
That was VERY helpful, however, when I say I am an SQL noob, I really am. :) It seems like 1) would return an SQL table, how would I go about accessing individual information from it? What would 2) return?. Would 3 just return an int that I could easily store in a VB variable.
I guess what I'm...
I've got a couple questions.
I'm trying to update a VB program of mine that accesses MS Access as a Database.
The database is sorted by one column, and I want it to be able to read the top 10 "rows" after that sort, but I have no idea how to do it. The only SQL I have ever written, if I could...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.