Solved

INSERT INTO (SQL)

Posted on 1998-02-26
1
191 Views
Last Modified: 2008-07-03
Hi, I need to insert a text field
let say (Bird's Eye) .
Ah ha ! See the problem .
SQL Insert requires me to put in Quotes (') before and after a string . For my case , a additional quote is found
and this generate an error to me .
For those who know how to to solve this problem please
help me .Okay . Thanks
0
Comment
Question by:seahpc
1 Comment
 
LVL 4

Accepted Solution

by:
yowkee earned 50 total points
ID: 1458026
  Use double quote: "Bird's Eye", or if you are using RDO in
VB to insert, use single quote 'Bird''s Eye' in the insert SQL string.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question