Problem in Insert query

  • Thread starter Thread starter navin
  • Start date Start date
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
 
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
 
Back
Top