# Sql does not update

**URL:** <https://forum.inductiveautomation.com/t/sql-does-not-update/41775>\
**Category:** Ignition\
**Created:** [December 24, 2020, 4:37am UTC](https://forum.inductiveautomation.com/t/sql-does-not-update/41775 "2020-12-24T04:37:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\
**Post date:** [December 24, 2020, 4:37am UTC](https://forum.inductiveautomation.com/t/sql-does-not-update/41775/1 "2020-12-24T04:37:32Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\
**Post date:** [December 24, 2020, 4:39am UTC](https://forum.inductiveautomation.com/t/sql-does-not-update/41775/2 "2020-12-24T04:39:14Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\
**Post date:** [December 24, 2020, 4:57am UTC](https://forum.inductiveautomation.com/t/sql-does-not-update/41775/3 "2020-12-24T04:57:27Z")

</div>

![parameterupdatesql](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/6/36aefde5b3efc1e59c7fd553e7101483def64bbb.png)

---

<div class="post-metadata">

**Author:** ![nathanielbrown](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nathanielbrown/32/9856_2.png) [@nathanielbrown](https://forum.inductiveautomation.com/u/nathanielbrown)\
**Post date:** [December 24, 2020, 5:31am UTC](https://forum.inductiveautomation.com/t/sql-does-not-update/41775/4 "2020-12-24T05:31:41Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\
**Post date:** [December 24, 2020, 2:53pm UTC](https://forum.inductiveautomation.com/t/sql-does-not-update/41775/5 "2020-12-24T14:53:48Z")

</div>

Thank you! case-sensitive resolved DRNum