how to update Table using SqliteManager in swift

Question

I am using SqliteManager to add data in database.

I have to update a table with the query below but it doesn't updating table data.

SQLiteManager.sharedInstance().executeQuery("UPDATE Invoice SET is_void = '1',void_comment ='\(txtComment.text)',void_date = '\(currentDateTime)' WHERE invoice_id = '\(inVoiceNumber)'")

Can someone please tell me what is wrong with this query or how can I check if the data is updated?

Structure of table Invoice

CREATE TABLE [Invoice]
(
   [is_void] INT,
   [void_comment] NVARCHAR(500),
   [void_date] NVARCHAR(50),
   [invoice_id] BIGINT,
)

Are you getting any error?, also show us the structure of `Invoice` table. — Nirav D, Sep 14 '16 at 05:05
None of the columns listed in the query seem to match the table you posted. — rmaddy, Sep 14 '16 at 05:11
Don't quote numeric values in the query. Better, properly bind values into the query (assuming SqliteManager supports that). — rmaddy, Sep 14 '16 at 05:15
No. `is_void = 1` instead of `is_void = '1'`. Remove the quotes from any numeric value. — rmaddy, Sep 14 '16 at 05:25
@rmaddy Yes this is working.but invoice number id dynamic.how to format in query — Krutarth Patel, Sep 14 '16 at 05:30
Can you show us the code how you are assigning value in `inVoiceNumber` variable. — Nirav D, Sep 14 '16 at 05:30
var tags = 0 tags = Int(sender.tag) inVoiceNumber = (arrSales[tags].valueForKey("invoice_id") as! String) — Krutarth Patel, Sep 14 '16 at 05:32
@NiravD i want to say as you said take invoice_id = 1. but this is dynamic — Krutarth Patel, Sep 14 '16 at 05:33

score 3 · Accepted Answer · answered Sep 14 '16 at 05:38

3

For dynamic inVoiceNumber, Just pass like this no nee to add single quote.

var inVoiceNumber = Int(arrSales[tags].valueForKey("invoice_id") as! String)
SQLiteManager.sharedInstance().executeQuery("UPDATE Invoice SET is_void = 1,void_comment ='\(txtComment.text)',void_date = '\(currentDateTime)' WHERE invoice_id = \(inVoiceNumber)")

answered Sep 14 '16 at 05:38

Nirav D

71,513
12
161
183

1

Welcome mate, Happy Coding :) – Nirav D Sep 14 '16 at 05:44
May i ask one more thing? – Krutarth Patel Sep 14 '16 at 05:48
@KrutarthPatel Yes what is it? – Nirav D Sep 14 '16 at 05:49
when i insert data it is inserting.i can check in log. but in table some time data not display – Krutarth Patel Sep 14 '16 at 05:50
1

Are you getting error if data is not insert in table, also show the code that you have used for inserting records. – Nirav D Sep 14 '16 at 05:52
i am adding invoicenumber at cellforrowatindexpath inVoiceNumber = (dic["invoice_num"] as? String)! when i use this value .query not working – Krutarth Patel Sep 14 '16 at 08:14
Query : UPDATE Invoice SET is_void = 1 ,void_comment ='Optional("")',void_date = '2016-09-14 16:15:11' WHERE invoice_id = 3) – Krutarth Patel Sep 14 '16 at 08:15
1

Sorry for late response may be the issue is with `void_comment ='Optional("")'` it should not contain optional like this in query. – Nirav D Sep 14 '16 at 09:50

how to update Table using SqliteManager in swift

1 Answers1