Syntax Error

Software technical issues not related to any of the other categories

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
azersci
Newcomer
Posts: 1
Joined: Thu Feb 06, 2020 7:11 pm

Syntax Error

Post by azersci » Thu Feb 06, 2020 7:23 pm

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)

User avatar
Mytch
NiceLabel Support
NiceLabel Support
Posts: 122
Joined: Fri Jul 13, 2018 10:26 pm
Location: Milwaukee, Wisconsin
Contact:

Re: Syntax Error

Post by Mytch » Thu Feb 06, 2020 8:46 pm

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

Post Reply