Page 1 of 1

Syntax Error

Posted: Thu Feb 06, 2020 7:23 pm
by azersci
I keep getting an error that "Number of query values and destination fields are not the same. " and I am completely stuck. Could anyone give me some direction on how to solve this issue or where I should be looking? Thanks!

INSERT INTO History
(CurrentYear,
PatientNumber,
SectionIn,
PatientName,
DOB,
ScannedDate,
SpecialStains,
LabelTemplate,
PrintDate)
VALUES
(:CurrentYear,
:PatientNumber,
:SectionIn,
:PatientName,
:DOB,
:ScannedDate,
:SpecialStains,
:LabelTemplate)

Re: Syntax Error

Posted: Thu Feb 06, 2020 8:46 pm
by Mytch
azersci,

The problem is you have 9 "destination fields" but only 8 "query values". In this case, it seems PrintDate is missing a value.

Regards,
Mytch