Results 1 to 6 of 6

Thread: Database connection

  1. May 19th, 2002, 03:13 PM #1
    Wolf
    Wolf is offline

    Thread Starter
    Member
    Join Date
    May 2000
    Location
    Sweden
    Posts
    50

    Question Database connection

    What's wrong with this code????

    Code:
    Produkt = "Ton"
adoPrimaryRS.Open "select PRODUKT,OLDARTNR,NEWARTNR,LEVARTNR from KROSSREF WHERE [PRODUKT] like '*" & Produkt & "*'", db, adOpenStatic, adLockOptimistic
    This should return all records containing "Ton", that is "Ton, tone, toner" and so on.
    But it doesn't return anything at all!?
    Wolf

    VB6 SP5
    Reply With Quote Reply With Quote
  2. May 19th, 2002, 03:15 PM #2
    Ultimasnake
    Ultimasnake is offline
    Frenzied Member Ultimasnake's Avatar
    Join Date
    Feb 2002
    Location
    Amsterdam, holland
    Posts
    1,172
    i think it is because you use [produkt] for the row (or whatever) but also use PRODUKT for the search name :S...
    For my PC and MS Smartphone 2003 software visit
    http://www.ultimasoftware.nl
    Reply With Quote Reply With Quote
  3. May 19th, 2002, 03:21 PM #3
    Wolf
    Wolf is offline

    Thread Starter
    Member
    Join Date
    May 2000
    Location
    Sweden
    Posts
    50
    Nope, allready tried that....
    Wolf

    VB6 SP5
    Reply With Quote Reply With Quote
  4. May 19th, 2002, 04:55 PM #4
    peet
    peet is offline
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    use % as wildcards, not *
    -= a peet post =-
    Reply With Quote Reply With Quote
  6. May 19th, 2002, 05:09 PM #5
    Wolf
    Wolf is offline

    Thread Starter
    Member
    Join Date
    May 2000
    Location
    Sweden
    Posts
    50

    Smile

    THANKS ALOT!!!
    That solved it
    Wolf

    VB6 SP5
    Reply With Quote Reply With Quote
  7. May 19th, 2002, 05:13 PM #6
    peet
    peet is offline
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    good

    always use % when working with ADO, the good o'l DAO likes the * ADO will not tolerate them
    -= a peet post =-
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width