please assit. Error 3144 Syntax error in UPDATE statement

bravura

New member
Local time
Today, 12:39
Joined
Jun 1, 2014
Messages
2
Please assist. unable to identify problem. I realize it's a lot. can question marks in table field names be the problem? or times in the dates (table set to mm/dd/yyyy)? ps. both INSERT and UPDATE commands have same error.

From Immediate window:

INSERT INTO tblA(STATUS,SCAC,VAN_TYPE,TCN,CONTAINER,BOOKING,PCFN,LOB_V,CONSIGNOR,CONSIGNEE,COMM_VOYDOC,VOYDOC,SAIL_DATE,POE,POD,VESSEL_STATUS,VESSEL_NAME,CARGO_DESC,METRIC,CUBE,LENGTH,WIDTH,HEIGHT,WEIGHT,MTON,COMMENT_ONE,COMMENT_TWO,TYPE,BB/CONTAINER,CREATE_DATE,STATUS_REASON,WORK_COMMENT,MAN_RCVD?,MAN_VALID?,HAS_VD?,SI_RECV,CARRIER_BKD?,CARRIER_HAS_SI?,IBS_STATUS,BRIGADE,BATTALION,MULTI-MODAL) VALUES ('Open','APLS','20 FT DRY','MX4002','USMU0144111','1112144','113815','1','MX4002','MMA900','SKN077','N2626','5/31/2014 12:00:00 PM','QA1','1Q1','VD','APL SOKHNA','REPAIR PARTS,VIC','NO','1360','240','96','102','17800','','MWY52R','','STANDARD','CONTAINER','5/31/2014 12:00:00 PM','','System Generated Open Status.','NO','NO','YES','4/20/2014 12:00:00 PM','YES','YES','MEASURED','595th','831st','NO');
 
Last edited:
Figuring it out.
1. Removed "/" from field name and syntax, replacing it with "_".
2. Removed "?" from field name and syntax.
3. Removed "-" from field name.
 
Last edited:
Thanks for following up with your solution. None of the symbols are a good idea (other than the underscore), but a workaround would have been to bracket the field name. Welcome to the site by the way!
 

Users who are viewing this thread

Back
Top Bottom