# SQLite ? near "17": syntax error

**URL:** <https://forums.kodeco.com/t/sqlite-near-17-syntax-error/25240>\
**Category:** iOS\
**Created:** [January 17, 2017, 4:04am UTC](https://forums.kodeco.com/t/sqlite-near-17-syntax-error/25240 "2017-01-17T04:04:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hcri50](https://s3.amazonaws.com/cdn.raywenderlich.com/community/forum-assets/noun-game-ghost-878668.png) [@hcri50](https://forums.kodeco.com/u/hcri50)\
**Post date:** [January 17, 2017, 4:04am UTC](https://forums.kodeco.com/t/sqlite-near-17-syntax-error/25240/1 "2017-01-17T04:04:37Z")

</div>

I am trying to do a Update to my column displayed “note” of my Sqlite Table.  
Please look at my Xcode graphic displaying the error and you will also see a copy of my Sqlite Table,  
I am at a loss on how to solve my syntax error “17”  
Can someone please tell me how to resolve my problem.

[Xcode Displaying Errors](http://www.hcri.com/wp-content/uploads/2017/01/xCode_Error.png)  
[My Sqlite DataBase](http://www.hcri.com/wp-content/uploads/2017/01/SqliteDataBase.png)

---

<div class="post-metadata">

**Author:** ![hcri50](https://s3.amazonaws.com/cdn.raywenderlich.com/community/forum-assets/noun-game-ghost-878668.png) [@hcri50](https://forums.kodeco.com/u/hcri50)\
**Post date:** [January 17, 2017, 5:36pm UTC](https://forums.kodeco.com/t/sqlite-near-17-syntax-error/25240/2 "2017-01-17T17:36:42Z")

</div>

Solved my problem with my sql query. for this was my problem. A silly mistake I made.  
Problem solved

const char \*sql = [[NSString stringWithFormat:@“update \_META\_DATA Set note=? Where stop\_time = "%@"”,\_stopTimeForNote] UTF8String];  
or I had it  
stop\_time = %@", \_stopTimeForNote]UIF8String];