SQLite Forum

SQL LITE Update
Login

SQL LITE Update

(1) By anonymous on 2020-04-18 20:46:24 [link] [source]

I have an SQL statement 

Database.executeUpdate("UPDATE RequestTable SET SupplyAmt = '"+intreqID1+"' WHERE ID='1-HS'");
 which is supposed to add the number 10 that is in my intreqID1 in my RequestTable in DBBrowser but it does not. How do I make sure that the number shows in the table?

(2) By Simon Slavin (slavin) on 2020-04-18 21:14:00 in reply to 1 [link] [source]

If intreqID1 is a number you don't need the apostrophes around it.

Can you insert a line into your program that prints out the SQL statement you're trying to execute ? I want to know whether the correct value is being inserted for intreqID1 .

Also can you execute

SELECT COUNT(*) FROM RequestTable WHERE ID='1-HS' ?

(3) By Larry Brasfield (LarryBrasfield) on 2020-04-18 21:18:00 in reply to 1 [source]

I'm guessing that you meant to do something resembling the following session:

sqlite> create table r (id int, sa real);
sqlite> insert into r values (1, 1.0);
sqlite> insert into r values (2, 2.0);
sqlite> update r set sa = sa+10 where id=2;
sqlite> select * from r;
id      sa
1       1.0
2       12.0
sqlite>

One problem with what you wrote is that your expression to which SupplyAmt is being set is merely a literal string. It specifies no arithmetic. Contrast that with the 4th line in above session screen-scrape.