Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

INSERT INTO (SQL)

Posted on 1998-02-26
1
Medium Priority
?
199 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 150 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

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…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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 process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses

886 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