Problem in Insert query

N

navin

Hi,

Please let me know what's wrong with the below, its giving error in
the last where the value is "True". Error is "Syntax Error in Insert
Into Statement"

INSERT INTO tblPOTracker (transDate, buyerName, businessGroup,
buyerReq, NoOfLines, reqCreatedDate, requestorName, buyerPO,
poSupplier, requestStatus, reqReceivedTime, reqClosedTime,
poTATLapsed, poTAT, poTATMissComments, poRemarks, poConfirmed,
confirmMode, approvalStatus, poPlaced) VALUES ('1/12/2008', 'Navin' ,
'HPS', 1234,3, '1/12/2008', 'navi', '34545', 'save test',
'Standard','1/12/2008 7:16:36 PM', '1/12/2008 7:16:14 PM', '-24:00',
'', '', '', '', '', 'Pending', True

Thanks,
Navin
 
M

MikeR

navin said:
Hi,

Please let me know what's wrong with the below, its giving error in
the last where the value is "True". Error is "Syntax Error in Insert
Into Statement"

INSERT INTO tblPOTracker (transDate, buyerName, businessGroup,
buyerReq, NoOfLines, reqCreatedDate, requestorName, buyerPO,
poSupplier, requestStatus, reqReceivedTime, reqClosedTime,
poTATLapsed, poTAT, poTATMissComments, poRemarks, poConfirmed,
confirmMode, approvalStatus, poPlaced) VALUES ('1/12/2008', 'Navin' ,
'HPS', 1234,3, '1/12/2008', 'navi', '34545', 'save test',
'Standard','1/12/2008 7:16:36 PM', '1/12/2008 7:16:14 PM', '-24:00',
'', '', '', '', '', 'Pending', True

Thanks,
Navin
Click to expand...
Two things:
You have 20 fields, but only 19 values
No closing parenthesis
HTH
Mike
 
Top