Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Having Trouble Manipulating SQL with VB
That makes perfect sense, you bring up a very good point, but it does not apply in my situation. I appreciate the idea though, for the future.- Jokeheads
- Post #7
- Forum: Visual Basic (Classic)
-
Having Trouble Manipulating SQL with VB
That works great. Perfect. Thank you very very much.- Jokeheads
- Post #5
- Forum: Visual Basic (Classic)
-
Having Trouble Manipulating SQL with VB
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...- Jokeheads
- Thread
- Replies: 7
- Forum: Visual Basic (Classic)
-
Three Query Questions for SQL
That makes a lot more sense, but how would the second one help me if it returns all the rows? -
Three Query Questions for SQL
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. -
Three Query Questions for SQL
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) -
Three Query Questions for SQL
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... -
Three Query Questions for SQL
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...
