Richard,
Check your insert statement for proper use of quotes. Whenever you are
inserting/updating, or selecting on a string (versus numeric) type of
field, your field values must be specified inside of quotes. Even
though it looks like you are using parameters, you probably need to have
something like: values("#parameter1#",....
Ryan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Richard Morrison
Sent: Tuesday, March 26, 2002 5:12 AM
To: [EMAIL PROTECTED]
Subject: [KCFusion] Can someone tell me what the hells wrong with this
sql statement
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
SQL = "insert into test (Area, GeoMarket, Ctry, Location,
LocationDescription, Family, Subfamily, Tag, Group, AssetDescription,
Co,
Rig, Quantity, Approval, Manufacturer, Model, Serial, PO, ServDateMMYY,
FA_TC01, FA_TC02, FA_TC03, FA_TC04, FA_TC05, FA_TC06, FA_TC07, FA_TC08,
FA_TC09) values( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
?
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )"
Query Parameter Value(s) -
Parameter #1 = LAM
Parameter #2 = VTT
Parameter #3 = VEN
Parameter #4 = 58258
Parameter #5 = VEN EAST OFFICE
Parameter #6 = 1
Parameter #7 = 1
Parameter #8 = 2
Parameter #9 = WL
Parameter #10 = VEHICLE TOYOTA 4X4 PU PC LONG
Parameter #11 = XE
Parameter #12 = 258
Parameter #13 = 1
Parameter #14 = TRN IN GEC
Parameter #15 = 1
Parameter #16 = 3
Parameter #17 = 3
Parameter #18 = 3
Parameter #19 = 297
Parameter #20 = 3
Parameter #21 = 3
Parameter #22 = 3
Parameter #23 = 3
Parameter #24 = 3
Parameter #25 = 3
Parameter #26 = 3
Parameter #27 = 3
Parameter #28 = 3
Data Source = "1"
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[email protected]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[email protected]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
