September 5, 2008 08:32pm pdt

Member Login

Hall of Fame

Yearly

1capricorn1 695,737
2boag2000 475,515
3LSMCons... 371,030
4DatabaseMX 336,668
5peter57r 254,302
6harfang 179,713
7jimhorn 144,623
8wiswalld 140,673
9koutny 86,850
10MikeToole 85,778
11hnasr 80,644
12eghtebas 79,977
13GRayL 79,924
14TextReport 76,173
15ldunscombe 75,386
16frankytee 74,964
17omgang 60,022
18LennyGray 56,432
19irudyk 56,350
20jefftwilley 54,970
21JDettman 53,870
22Rick_Ric... 53,365
23mbizup 52,052
24matthews... 44,897
25JezWalters 43,325

	[x] Attachment Details

MS ACCESS QUERY

Zones: Access Forms, Microsoft Visual Basic.Net, SQL Query Syntax

I am using MS ACCESS as database and C# windows application..
While i am trying to insert a name with single quote(') access throws error.
Let me know about the syntax.

Thanks in advance

         
             string query="insert into table1(CODE,NAME,LOCATION,JOBNO) values ('" + strCode+"','"+strPrjName+"','"+strLocation+"','"+strJobNo+"')";
 
i have (') in strPrjName and strLocation

Start your free trial to view this solution

Question Stats

Zone: Microsoft

Question Asked By: lword

Question Asked On: 07.18.2008

Participating Experts: 3

Points: 500

Translate:

Loading Advertisement...

20080723-EE-VQP-34 / EE_QW_2_20070628