dcsimg
Results 1 to 6 of 6

Thread: [RESOLVED] syntax error

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2013
    Posts
    685

    Resolved [RESOLVED] syntax error

    Hello
    I'm getting a syntax error with this query.
    Code:
    RS.Open "select * from Tbl1" & _
    " WHERE Date_Rend <> '" & "" & _
    "and (Date_Rend <> #" & Format(Date, "mm/dd/yyyy") & "#)", DB, adOpenStatic, adLockOptimistic
    Would you please correct me
    thanks a lot

  2. #2
    VB-aholic & Lovin' It LaVolpe's Avatar
    Join Date
    Oct 2007
    Location
    Beside Waldo
    Posts
    18,572

    Re: syntax error

    That 2nd line of your query looks odd. Try printing out you query to the debug/immediate window and look at it. Does it look right?
    Insomnia is just a byproduct of, "It can't be done"

    Classics Enthusiast? Here's my 1969 Mustang Mach I Fastback. Her sister '67 Coupe has been adopted

    Newbie? Novice? Bored? Spend a few minutes browsing the FAQ section of the forum.
    Read the HitchHiker's Guide to Getting Help on the Forums.
    Here is the list of TAGs you can use to format your posts
    Here are VB6 Help Files online


    {Alpha Image Control} {Memory Leak FAQ} {Unicode Open/Save Dialog} {Resource Image Viewer/Extractor}
    {VB and DPI Tutorial} {Manifest Creator} {UserControl Button Template} {stdPicture Render Usage}

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2013
    Posts
    685

    Re: syntax error

    Thanks sir
    this is the output
    Code:
    select * from Tbl1 WHERE Date_Rend <> 'and (Date_Rend <> #01/19/2018#)

  4. #4
    VB-aholic & Lovin' It LaVolpe's Avatar
    Join Date
    Oct 2007
    Location
    Beside Waldo
    Posts
    18,572

    Re: syntax error

    Hmm, you do see the problem with that query don't you?
    Insomnia is just a byproduct of, "It can't be done"

    Classics Enthusiast? Here's my 1969 Mustang Mach I Fastback. Her sister '67 Coupe has been adopted

    Newbie? Novice? Bored? Spend a few minutes browsing the FAQ section of the forum.
    Read the HitchHiker's Guide to Getting Help on the Forums.
    Here is the list of TAGs you can use to format your posts
    Here are VB6 Help Files online


    {Alpha Image Control} {Memory Leak FAQ} {Unicode Open/Save Dialog} {Resource Image Viewer/Extractor}
    {VB and DPI Tutorial} {Manifest Creator} {UserControl Button Template} {stdPicture Render Usage}

  5. #5

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2013
    Posts
    685

    Re: syntax error

    Code:
    Hmm, you do see the problem with that query don't you?
    I tried a lot but I get error with data type or syntax error

  6. #6

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2013
    Posts
    685

    Re: syntax error

    solved
    Code:
    WHERE Date_Rend Not Is Null

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width