User Profile

Collapse

Profile Sidebar

Collapse
goforth4
goforth4
Last Activity: Mar 6 '08, 02:39 PM
Joined: Mar 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • goforth4
    replied to Replacing apostrophe in a recordset for SQL insert
    in Access
    I can advise you where to look.

    Not 100% sure how..

    But I'd search on how SQL insert statements handle apostrophes in inserting data.

    Then I'd use the technique to 'replace' apostrophes with whatever the syntax SQL is appropriate for the database/SQL.

    e.g.
    Code:
    tempStr = "String with apost'rophe"
newStr = replace(tempStr,"'","''") ''DOUBLE
    ...
    See more | Go to post

      Leave a comment:

    • goforth4
      started a topic Sol: no ezshellextensions issue in VS 2005
      in .NET

      Sol: no ezshellextensions issue in VS 2005

      Transfering code from one machine to another ezshellextensio ns can error sometimes.

      To fix it I had to reinstall VS 2005 (could have been a bad install).
      I then updated to SP1.
      Remove all the code in the 'running' directory (i.e. move and zip for safe keeping)
      Then rebuild.
      Go to the ezshell error.
      Remove reference.
      Add Reference.
      Add the Ezshellextensio n again.
      Fixed that er...
      See more | Go to post
      No activity results to display
      Show More
      Working...