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)
i am getting this error:
GatewayException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ‘:’.
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.
Thank you! case-sensitive resolved DRNum