Results 1 to 6 of 6

Thread: query problem with ms access too..

  1. #1
    Join Date
    Jul 2004
    Posts
    153
    Rep Power
    0

    Default query problem with ms access too..

    I have the following code segment:
    Public Function getprodcatgrylist() As DataSet

    Try
    sqlStr = "Select Distinct Category from tblProducts"
    DA = New OleDb.OleDbDataAdapter(sqlStr, connect())
    DA.Fill(dset, "dtproductcategory")

    DA.Dispose()
    getprodcatgrylist = dset
    Catch ex As Exception
    Throw ex
    finally
    if connect.state = connectionstate.open then
    connect.close()
    end if
    End Try
    End Function

    pretty simple and straight forward.
    The thing is when ran from the app this returns 2 more records than it should and the data is still wrong...when the query is ran in access...its as good as it can get...whats the deal...MS Access sucks...never had this prob. with MSSQL...

  2. #2
    Join Date
    Dec 2002
    Posts
    500
    Rep Power
    0

    Default

    would help if we saw the results or part of it to see what exactly is wrong with it.
    Cultured in Aggression and Koding like a Warrior!!
    “Common sense is instinct. Enough of it is genius.” - George Bernard Shaw.
    "The significant problems we face cannot be solved by the same level of thinking that created them." - Albert Einstein

  3. #3
    Join Date
    Feb 2005
    Posts
    73
    Rep Power
    0

    Default

    I had a very similar problem that was solved in this forum, I don't have time for a few days but you might find a solution by looking for posts that I started.

    I will try and help if I do run into some time,

    Good luck

  4. #4
    Join Date
    May 2006
    Posts
    467
    Rep Power
    0

    Smile

    http://www.techjamaica.com/forums/sh...ad.php?t=23511

    I hope this was the article that OffRoad was speaking about --- read the few posts and hopefuly it will assist you!


    Good luck in sorting it out!
    "I don't procrastinate! I just manage my available time in an inefficient manner!"

  5. #5
    Join Date
    Jul 2004
    Posts
    153
    Rep Power
    0

    Default

    thanks all for the help...but i solved this some time ago...can't remember exactly what was the problem..

  6. #6
    Join Date
    Feb 2005
    Posts
    73
    Rep Power
    0

    Default

    I can't remember what I did yesterday, so you are forgiven for not remembering a year ago, I suppose.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •