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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jokeheads

    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.
  2. Jokeheads

    Having Trouble Manipulating SQL with VB

    That works great. Perfect. Thank you very very much.
  3. Jokeheads

    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...
  4. Jokeheads

    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?
  5. Jokeheads

    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.
  6. Jokeheads

    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)
  7. Jokeheads

    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...
  8. Jokeheads

    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...

Part and Inventory Search

Back
Top