Sql does not update

Ignition
1

INSERT INTO LineDTL3 (L3H1, L3H2, L3H3, L3H4, L3H5, L3H6, LineID, EmployeeID, DRNum, TruckNum, DateTimeInput, CT) VALUES (:L3H1, :L3H2, :L3H3, :L3H4, :L3H5, :L3H6, :LineID, :EmployeeID, :DRNum, :TruckNum, :DateTimeInput, :CT)

2

i am getting this error:
GatewayException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ‘:’.

3

parameterupdatesql
parameterupdatesql911×324 56.9 KB

4

It looks like the parameter “DRNum” in your insert statement doesn’t match that in Ignition named query parameter section (which has it listed as “DrNum”). Try capitalizing the “r” and that should correct the error being generated.

2 Likes
5

Thank you! case-sensitive resolved DRNum

2 Likes