BobRodes's Profile User Rating: *****

Reputation: 594 Enlightened
Group:
Expert
Active Posts:
3,068 (1.25 per day)
Joined:
19-May 09
Profile Views:
57,293
Last Active:
User is offline Jan 30 2016 11:43 PM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Mac
Favorite Browser:
Safari
Favorite Processor:
Who Cares
Favorite Gaming Platform:
XBox
Your Car:
Mercedes
Dream Kudos:
0
Expert In:
VB6/VB.NET

Latest Visitors

Icon   BobRodes is a paragon of ignorance.

Posts I've Made

  1. In Topic: Document Classification and Suggestion

    Posted 5 Dec 2015

    Here's a different approach, perhaps, that might simplify your problem.

    Your underlying problem is the same as that addressed by search engines: you have a number of documents (analogous to web pages) and you want to serve up a list of documents relevant to criteria that users enter. So, you probably can get a lot of practical information by studying SEO techniques. Google (meaning Google's own site, not googling for information) has a great deal of information on this. You might start here.

    The information on how to make pages easier to find translates into how to make your own documents easier to find. As you begin to get ideas on improving the findability of the documents, you should begin to home in on more specific ideas on how to create the engine that finds them.
  2. In Topic: Use case to class diagram

    Posted 5 Dec 2015

    Your class diagram looks pretty good. What you are missing is formalized detail about the use cases. This is handled with a use case narrative. You can find out more about those here. If you want to support your narrative with a diagram, use an Activity diagram. Going through this exercise may well uncover other classes that you will need.
  3. In Topic: No records displayed if one column has no data or single record only.

    Posted 5 Dec 2015

    In terms of set theory, an inner join returns the intersection of two sets. If one of the sets is empty, then the intersection is also empty. So, if you have three inner joins, you will get an empty result set if any of the joined sets is empty.

    Now, a left join returns all values in the leftmost of the two sets, and only those in the right set that match values in the left set. If there are no values in the right set, the result will have a record with null values for the fields in that set. There is also a right join, where the reverse is true, and an outer join (in most flavors of SQL), which combines left and right joins and can get slow and unwieldy quickly, especially if you are using more than one.

    Suppose you have these tables:
    TableA
    ID    FName    LName
    1     Bob      Rodes
    2     John     Rodes
    3     David    Rodes
    
    
    TableB
    ID    AID      EyeColor
    1     1        Green
    2     3        Brown
    
    


    Now:

    SELECT FName, LName, EyeColor FROM TableA a INNER JOIN TableB b ON a.ID = b.AID
    SELECT FName, LName, EyeColor FROM TableA a LEFT JOIN TableB b ON a.ID = b.AID
    
    


    will have these results:

    FName    LName    EyeColor
    Bob      Rodes    Green
    David    Rodes    Brown
    
    FName    LName    EyeColor
    Bob      Rodes    Green
    John     Rodes    NULL
    David    Rodes    Brown
    
    


    So, as modi says, you probably are looking to use LEFT JOIN.
  4. In Topic: some of friends say vb is outdated Is it true?

    Posted 5 Dec 2015

    While VB6 is as dead as a vampire, it is also vastly superior to VB.Net in terms of ease of use and access to low-level routines. However, only old people are allowed to use it.
  5. In Topic: Nested query in visual basic

    Posted 5 Dec 2015

    This should work, and is a nested query:
    SELECT COUNT(*) FROM (SELECT DISTINCT PlayQuery FROM PLAYS)
    
    

    Your code doesn't save the file anyway. The way to do that would be
    SELECT DISTINCT PlayQuery INTO DistinctPlayersQuery FROM PLAYS
    SELECT COUNT(*) FROM DistinctPlayersQuery
    DROP TABLE DistinctPlayersQuery
    
    

    If you just "save the SQL" you are actually creating a stored procedure, or you would save as a text file--but to do that, you'd have to use the SQL Server Manager to load and execute it.

My Information

Member Title:
Lovable Curmudgeon
Age:
59 years old
Birthday:
September 15, 1956
Gender:
Location:
Manchester, Tennessee
Interests:
IT, Music.
Forum Leader:
VB6, VB.NET
Full Name:
Bob Rodes
Years Programming:
25
Programming Languages:
BASIC, VB6, VB.Net, C#, Java, Javascript, CSS, also UML

Contact Information

E-mail:
Click here to e-mail me

Comments

Page 1 of 1
  1. Photo

    lucky3 Icon

    31 Dec 2012 - 02:30
    Congratulations for the "Expert of the Year" 1st place award!
  2. Photo

    Elda Icon

    23 Jul 2012 - 19:09
    Congratulations. You're an expert. you deserved it. :)
  3. Photo

    trevster344 Icon

    15 Jun 2012 - 17:53
    I found your post in the thread, that is now locked in the .net forum, to be quite humorous. Just wanted to say I appreciate your work and effort helping people out, because sometimes I don't have the patience myself to sit there spoon feeding people information. Thanks :)
  4. Photo

    15Dhan Icon

    01 May 2012 - 18:15
    Congrats .. IDOL :)
  5. Photo

    haidar976 Icon

    18 Aug 2011 - 23:55
    How can you manage all these languages without be confusing between them? I tried to learn C++ then after few months changed to VB6 I completely forgot every thing about C++, I cant work with two language in the same time
    You are expert man
  6. Photo

    BobRodes Icon

    15 Feb 2011 - 15:02
    Thanks for the recognition. I'm honored.
  7. Photo

    Dogstopper Icon

    14 Feb 2011 - 19:35
    Congratulations on Expert!
Page 1 of 1