Problem in Insert query

[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

 

[MikeR]

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

Two things:
You have 20 fields, but only 19 values
No closing parenthesis
HTH
Mike

 

[Steve Schapel]

.... and a third thing: dates should be delimited with #s instead of ''s.

 

[MikeR]

... and a third thing: dates should be delimited with #s instead of ''s.

Nice catch!