Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303

    Angry Unanswered: vb sql with single qoute

    hi,

    How to write a vb sql statement that insert record with a single qoute.

    thanks...

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Double the quote (apostrophe), something like:
    Code:
    INSERT INTO myTable (thisColumn)
       VALUES ('I can''t insert blasted apostrophes.')
    -PatP

  3. #3
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303
    thanks pat,
    But I got some other way to solve my problem using vb parameter <?> question mark.

    thanks...

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    As I wrote in the other thread on this topic, using ADO as you're suggesting is actually a better answer. I'm glad that works for you!

    -PatP

Posting Permissions

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