CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6

Thread: " Quot Problem

  1. June 6th, 2003, 07:00 AM #1
    Satishatakare
    Satishatakare is offline Junior Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    22

    " Quot Problem

    I have to insert address of customer into SQL Server Database/Access Database containing Double Quote

    Ex:
    Customer Address:
    "XYZ House", New Road, Colony, City.

    How to handle it in Visual Basic for Insert and Update.
    Satish
    Reply With Quote Reply With Quote
  2. June 6th, 2003, 07:07 AM #2
    M Owen
    M Owen is offline Senior Member
    Join Date
    Jun 2001
    Location
    Mi
    Posts
    1,249
    You can escape it or use a recordset and "poke" it across ...
    Reply With Quote Reply With Quote
  3. June 6th, 2003, 08:04 AM #3
    Pinky98's Avatar
    Pinky98
    Pinky98 is offline Senior Member
    Join Date
    Dec 2002
    Location
    London, UK
    Posts
    1,569
    Use double qoutes.
    e.g.

    SQLStatement = "UPDATE blahblahblah...""XYZ House"", New Road, Colony, City"
    Mike
    Reply With Quote Reply With Quote
  4. June 6th, 2003, 08:51 AM #4
    M Owen
    M Owen is offline Senior Member
    Join Date
    Jun 2001
    Location
    Mi
    Posts
    1,249
    Mike,

    I always hesitate on giving that answer because in VBA I can never get it to work ... ADO pukes when I try that ... I end up having to open a recordset and poking the string across that way ...
    Reply With Quote Reply With Quote
  6. June 6th, 2003, 10:07 AM #5
    Pinky98's Avatar
    Pinky98
    Pinky98 is offline Senior Member
    Join Date
    Dec 2002
    Location
    London, UK
    Posts
    1,569
    Odd. I've never had a problem. Must be a "bit of bug" in the VBA compiler.
    Mike
    Reply With Quote Reply With Quote
  7. June 6th, 2003, 11:40 AM #6
    M Owen
    M Owen is offline Senior Member
    Join Date
    Jun 2001
    Location
    Mi
    Posts
    1,249
    Must be ... Now I have the fun of reworking all my forms because they are too slow with using ADO in VBA ... Doesn't that sound like fun?????
    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

Featured