# How can i change a bit from ignition to SQL server

**URL:** <https://forum.inductiveautomation.com/t/how-can-i-change-a-bit-from-ignition-to-sql-server/79225>\
**Category:** Ignition\
**Tags:** scripting, ignition79\
**Created:** [September 15, 2023, 4:09pm UTC](https://forum.inductiveautomation.com/t/how-can-i-change-a-bit-from-ignition-to-sql-server/79225 "2023-09-15T16:09:21Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 15, 2023, 4:22pm UTC](https://forum.inductiveautomation.com/t/how-can-i-change-a-bit-from-ignition-to-sql-server/79225/2 "2023-09-15T16:22:50Z")

</div>

The line you're looking for is,

```auto
Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: 
    SQL error for UPDATE Actividades.Machine_ledger SET Check = ? WHERE Row = ?": 
    Incorrect syntax near the keyword 'Check'.

```

(I had to use OCR to extract the error message so there may be errors in it. Tip: post text - not pictures of errors or code. When posting code format it properly. See link below.)

It looks like you are expecting a column 'Check' but the database doesn't have one.

> [@Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831):
>
> This thread is intended as a short help file for all those struggling to post formatted code on the forum. Posting formatted code on the forum (and most others) is as simple as selecting the code and pressing the \</\> button. It works the same as applying Bold or Italic styles to your document. It preserves indentation and applies syntax highlighting. [How to post code]

---

_[View the full topic](https://forum.inductiveautomation.com/t/how-can-i-change-a-bit-from-ignition-to-sql-server/79225)._