Tek Inserts
I am having a problem with an insert statement in Visual Basic 8 connecting to an Access Database.?
Getting syntax error in INSERT TO statement. That is all the information I get. Here is my code. Parameters are set after last statement
Dim Cmd As OleDb.OleDbCommand
Dim Con As OleDb.OleDbConnection
Dim Sql As String = Nothing
Con = New OleDb.OleDbConnection(“Provider=Microsoft.Jet.OleDb.4.0;data source=” & “C:Documents and SettingsMPAXTON1My DocumentsVisual Studio 2008ProjectsGunLogGunLogTeklogixReturnLog.mdb” & “”)
Sql = “INSERT INTO GunLog(date, sc_num, wh_id, gun, model, send_tek, sendRMA, return_tek, returnRMA, problem, employee, call_tek, tek_assoc, tek_sc) VALUES (@date, @sc_num, @wh_id, @gun, @model, @send_tek, @sendRMA, @return_tek, @returnRMA, @problem, @employee, @call_tek, @tek_assoc, @tek_sc)”
Cmd = New OleDb.OleDbCommand(Sql, Con)
I tried the single quotes and got the same message. 
I think your problem is that you are not concidering the diference between numeric and string
try this
if the column is string have single qutes aroud the item for example
‘{0}’
Sql = String.Format(“INSERT INTO GunLog(date, sc_num, wh_id, gun, model, send_tek, sendRMA, return_tek, returnRMA, problem, employee, call_tek, tek_assoc, tek_sc)
VALUES ({0} , {1} , {2} , {3} , {4} , {5} , {6} , {7} , {8} , {9} , {10} , {11}, {12} , {13} ) “,
date, sc_num, wh_id, gun, model, send_tek, sendRMA, return_tek, returnRMA, problem, employee, call_tek, tek_assoc, tek_sc )
Door Inserts , Door Lite Tek, www.windowinserts.com
|
|
2000 Topps Tek Architek Pedro Martinez Insert $0.99 |
|
|
INSERT SET: Tek World T1-4 & Prototypes 1-3 $4.99 |
|
|
SET & INSERTS: Tek World T1-4 & Prototypes 1-3 $3.99 |
|
|
2000 TOPPS TEK ARCHITEKS SP INSERT #AT3 CHIPPER JONES $1.95 |
|
|
2000 TOPPS TEK DRAMATEK PERFORMERS INSERT CHIPPER JONES $1.25 |
|
|
2000 TOPPS TEK TEKTONICS RARE SP INSERT CHIPPER JONES $3.95 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 1999-2002 Silverado 1500 $146.94 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 2002-2003 Dodge Ram 1500 $133.94 |
|
|
NEW MATRIX/TRUCK TEK GRILLE INSERT 17441 FORD F150 $74.95 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 1997-2002 Ford Expedition $112.94 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 2000-2004 Toyota Tundra $112.94 |
|
|
4 insert’s / rare cards, Nolan ryan triad – Cal ripken TEK – Beasley rookie $9.85 |
|
|
9x Rare Insert Lot Randy Johnson Fleer Tradition Topps Tek Upper Deck MVP +++ $9.95 |
|
|
NOMAR GARCIAPARRA TOPPS TEK ROOKIE OF THE YEAR #38A P-24 VERY RARE STAR INSERT $25.00 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 2001-2003 Toyota Tacoma $121.90 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 2002-2003 Dodge Ram 1500 $141.90 |
|
|
00 Topps Tek – DEREK JETER – TEKTRONICS Insert!!! $7.25 |
|
|
LARRY WALKER 2000 TOPPS TEK ARCHITEK INSERT #A9 COLORADO ROCKIES *07 $2.50 |
|
|
NES Nintendo INSERT: GAME TEK… WE’RE INTO FUN AND GAMES! $6.74 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 2003-2004 Jeep Grand Cherokee $233.94 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 1985-2004 Chevrolet Astro $121.90 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 1989-1996 Ford Bronco $121.90 |
|
|
DAN MARINO 1995 Collector’s Edge Excalibur TekTech #7 Tek Tech Prism Insert Card $20.00 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 1997-2003 Ford F-150 09-3085 $87.94 |
|
|
R05381 1999 Topps Tek Teknicians MARK McGWIRE Insert Cardinals $8.98 |
|
|
5x Rare Insert Lot Craig Biggio Topps Tek Topps Chrome Refractor Topps Winner $6.95 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 1988-1998 Chevrolet C/K 1500 $94.94 |
|
|
ROBIN VENTURA **Rare** 1998 Topps Tek Parallel Insert Card *Diffractor* SEE THRU $29.99 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 2001-2003 Ford F-150 $131.90 |
|
|
10 PCS Tektronix Tek Knob Insert 377055000/377-0550-00 $14.99 |
|
|
10 PCS Tektronix Tek Knob Insert 377041300/377-0413-00 $14.99 |
|
|
NES Nintendo Game Tek poster / insert! $5.95 |
|
|
1999 Topps TEK TEKnicians Insert T2 Mark McGwire *A8 $6.00 |
|
|
1999 1999 2000 TOPPS TEK 55CT W/MCGWIRE JOSH HAMILTON FRANK INSERTS RC $45.00 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 1997-2003 Ford F-150 $121.90 |
|
|
Matrix Truck-Tek Taillights Euro Clear/Red Inserts 2003-2006 Silverado 1500 $157.90 |
|
|
9x Rare Insert Lot Nomar Garciaparra Omega Topps Tek Pinnacle Showcase Chrome ++ $10.95 |
|
|
Nomar Garciaparra 2000 Topps Tek DramaTek Performers Insert Card #DP4 Red Sox $2.09 |
|
|
2000 Topps Tek Dramtek Performers Insert #1 Mark McGwire $4.78 |
|
|
Chipper Jones 2000 Topps Tek ArchiTEK Insert #A3 $3.23 |
|
|
Inserts $3.26 Inserts |
|
|
Disco Tek $10 Disco Tek – Yunis |
|
|
Eqyss Micro-Tek Spray $24.49 Eqyss Micro-Tek Spray |
|
|
Tek Hand Sprayers $38.08 Tek Hand Sprayers |
|
|
Tek Sprayer Maintenance Kits $10.25 Tek Sprayer Maintenance Kits |
|
|
Kwik Tek Telescoping Paddle $20.95 Kwik Tek Telescoping Paddle |
|
|
Ark Tek Theme $10 Ark Tek Theme – Indiana JonesIV |
|
|
Stock Inserts Inserts 10-Pak $29.95 CNC machined threaded brass bushings provide added strength and security for screwing down sling studs recoil pads and triggerguards in wood composite and fiberglass stocks. Lets you turn a screw in tight without the worry of stripping it out of the stock material. Heavily knurled on the outside to hold plenty of epoxy bedding for a rock-solid grip between the insert and stock. Kits available for mounting sling studs recoil pads and Remington ADL triggerguards plus a 10-pak of general use inserts. Mfg: Brownells SPECS: Brass knurled. ½" (12.7mm) long x 5⁄16" (7.9mm) diameter. All inserts have 10-32 tpi internal threads. Sling Stud Inserts – (2) inserts (2) steel dome-top sling studs matte blued. Recoil Pad Inserts – (2) inserts (2) ¾" (19mm) long stainless steel roun |
|
|
Rubber Inserts: D21Xd17XH15 Rubber Inserts 1Pc $1 Rubber Inserts: D21Xd17XH15 Rubber Inserts 1Pc |
|
|
SportDOG / Tek Series 1.0 E-Collar Module / TEK-T $199.95 SportDOG – Tek Series 1.0 E-Collar Module – TEK-T |
|
|
SportDOG / Tek Series 1.0 Add-A-Dog Collar / TEK-AD $299.95 SportDOG – Tek Series 1.0 Add-A-Dog Collar – TEK-AD |
|
|
Table,Iflex Full Tbl,Tek $236.99 TABLE,IFLEX FULL TBL,TEK |
|
|
Table,Iflex File Cbnt,Tek $100.99 TABLE,IFLEX FILE CBNT,TEK |
|
|
Kwik Tek Airhead Fiji Float $24.95 Kwik Tek Airhead Fiji Float |
|
|
Words From Tek $6 Words From Tek – Boot Camp Clik |
|
|
C-Tek 56380 $19.98 C-Tek 56380 56380 Comfort Indicator Panel |
|
|
C-Tek 56865 $42.99 C-Tek 56865 56865 US .8 |