issue while updating value in sqlite table with update query

Question

I'm implementing sqlite in my swift project and with update query i am updating some value from table but i am getting syntax error i am not sure why i am getting error.

UPDATE Code

 let updateStatementString = "UPDATE CreateInspDrawingDetail SET edit_file_name = \(self.imgbase64!) WHERE property_id = \(property_ID!) AND properties_drawings_id = \(self.drawingID!)"
 var updateStatement: OpaquePointer? = nil
 if sqlite3_prepare_v2(db, updateStatementString, -1, &updateStatement, nil) == SQLITE_OK {
        if sqlite3_step(updateStatement) == SQLITE_DONE {
               print("Successfully updated row.")
        } else {
               print("Could not update row.")
        }
      } else {
            print("UPDATE statement could not be prepared")
      }
      sqlite3_finalize(updateStatement)

i am getting syntax error like below

near "/": syntax error UPDATE statement could not be prepared

i am do anything wrong in my query please tell me

Don't assign updateStatement as nil. var updateStatement : OpaquePointer? — manishsharma93, Jun 19 '19 at 11:18
Try to change SQLITE_DONE to SQLITE_OK. In the first if condition with nil for updateStatement. — manishsharma93, Jun 19 '19 at 11:25
Okay i am trying but can you please tell me query syntax is right? — Vishal Parmar, Jun 19 '19 at 11:25
Have you tried to print the statement before preparing it to see if it looks ok with the property values inserted? — Joakim Danielson, Jun 19 '19 at 11:51

steveSarsawa · Accepted Answer · 2019-06-19T11:42:35.833

4

Try this

let updateStatementString = "UPDATE CreateInspDrawingDetail SET edit_file_name = '\(self.imgbase64!)' WHERE property_id = '\(property_ID!)' AND properties_drawings_id = '\(self.drawingID!)';"
 var updateStatement: OpaquePointer? = nil
 if sqlite3_prepare_v2(db, updateStatementString, -1, &updateStatement, nil) == SQLITE_OK {
        if sqlite3_step(updateStatement) == SQLITE_DONE {
               print("Successfully updated row.")
        } else {
               print("Could not update row.")
        }
      } else {
            print("UPDATE statement could not be prepared")
      }
      sqlite3_finalize(updateStatement)

edited Jun 19 '19 at 11:42

answered Jun 19 '19 at 11:31

steveSarsawa

1,559
2
14
31

Okay let me try – Vishal Parmar Jun 19 '19 at 11:36
WelCome Happy Coding :) – steveSarsawa Jun 20 '19 at 04:39

issue while updating value in sqlite table with update query

1 Answers1